Using Oracle Directories
Disk Group Oracle Directories
ALTER DISKGROUP dskgrp01 ADD DIRECTORY
‘+dskgrp01/new10gdb’;
To add a new Oracle directory called newuser under
new10gdb, use the following Oracle directory command.
ALTER DISKGROUP dskgrp01 ADD DIRECTORY
‘+dskgrp01/new10gdb/newuser’;
Care should be taken to see that relative
paths are accurate when altering an Oracle
directory, and that no subdirectory
is left out in this process.
To rename an Oracle directory, use the RENAME
DIRECTORY clause as follows:
ALTER DISKGROUP dskgrp01 RENAME DIRECTORY
‘+dskgrp01/new10gdb/newuser’ to
‘+dskgrp01/new10gdb/createuser’;
Similar to disk group templates, an Oracle
directory can be dropped. To drop an Oracle
directory, use the DROP DIRECTORY clause.
Use the FORCE clause to drop Oracle
directories with contents. System created
Oracle directories cannot be dropped.
In our above example, the new Oracle directory
has createuser underneath it in the tree
structure. To drop the new Oracle directories,
use the following command:
ALTER DISKGROUP dskgrp01 DROP DIRECTORY
‘+dskgrp01/new10gdb’ FORCE;
|
|
