Mijan's Database and OS Learning Blog

This is a knowledge and information sharing blog of oracle single instance and RAC database. Some part of it has basic UNIX OS discussions.

Pages

Awm king

Nobin

Gamer

Check Datafile Usage and Resize a Datafile Oracle 10g Onward.

Due to space constraints or some other issue, we may need to resize a datafile in Oracle. If the datafile is mostly unused (Partially used...
Append of Spool while running sql script

This is my Script: spooltest.sql ------------------------ spool C:\Users\DoICT_Borhanuddin\Desktop\record.txt append alter session set conta...
Checking Roles of a user in oracle.

From SYS (To see all the privileges sys can provide to a user): select * from role_sys_privs; From DBA user: select * from dba_role_privs ...

Powered by Blogger.