Search This Blog

Wednesday, February 23, 2011

Oracle directories

Few basic information on oracle directories:

Related Data Dictionary Objects: all_directories and dba_directories
Create directory syntax :
sys>create or replace directory XYZ as '/oracle/path';
sys> grant read,write on directory XYZ to apps;
sys> select * from dba_directories;

No comments:

Post a Comment

Transportable tablespace refresh

  1.check tablespace for the user which need to refresh -------------------------------------------------------------------  SQL> select ...