Mijan's Database and OS Learning Blog

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 ...

Search This Blog

Powered by Blogger.