If you were allowed to specify a directory path location for an output file, then the server might overwrite a file that you might not normally have privileges to delete. If you were allowed to specify a directory path location for an input file, then you might be able to read data that the server has access to, but to which you should not. The reason that a directory object is required is to ensure data security and integrity. SQL> CREATE DIRECTORY dpump_dir1 AS '/usr/apps/datafiles' The following example shows a SQL statement that creates a directory object named dpump_dir1 that is mapped to a directory located at /usr/apps/datafiles. DBAs must ensure that only approved users are allowed access to the directory object associated with the directory path. A directory object maps a name to a directory path on the file system. Data Pump requires that directory paths be specified as directory objects. Because Data Pump is server-based rather than client-based, dump files, log files, and SQL files are accessed relative to server-based directory paths.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |