oracle - export and import schema using expdp and impdp -
i use this tuotrial export/import schema. steps in tutorial working until expdp command, see screenshot:
i using oracle12c. idea?
the article linked to notes that:
the directory object pointer physical directory, creating not create physical directory on file system of database server.
you have create physical operating system directory separately, outside database. physical directory has readable , writable operating system user running oracle database; seem on windows account services running under.
you can create physical directory before or after creating directory object independent, except when oracle trying access through utl_file or related activity - data pump uses utl_file, can see error message stack.
the create directory
doesn't check physical directory points exists; , can delete or create physical directory without oracle noticing; long there accessible when try use it.
from the oracle documentation:
a directory object specifies alias directory on server file system ...
and
for file storage, must create corresponding operating system directory, oracle automatic storage management (oracle asm) disk group, or directory within oracle asm disk group. system or database administrator must ensure operating system directory has correct read , write permissions oracle database processes.
privileges granted directory created independently of permissions defined operating system directory, , 2 may or may not correspond exactly. example, error occurs if sample user hr granted read privilege on directory object corresponding operating system directory not have read permission defined oracle database processes.
Comments
Post a Comment