Datapump
Exporting table
syntax
Example-->
usename_taking_export---> is the user as whom you are taking export backup.Can be the owner of table or any other user who has required privileges.
directory--> a directory which has been created & from above username_taking_export user should have been granted read, write privileges. It is here the dumpfiles are going to be created.
tables--> if the table is to be exported from another schema, then qualify it with the schema/user name
Exporting table
syntax
expdp username_taking_export/passwd directory=directory_name dumpfile=some_related_name.dmp logfile=some_related_name.log tables=username.table_name
Example-->
expdp system/passwd directory=dba_dir dumpfile=exp_scott_emp.dmp logfile=exp_scott_emp.log tables=scott.emp
usename_taking_export---> is the user as whom you are taking export backup.Can be the owner of table or any other user who has required privileges.
directory--> a directory which has been created & from above username_taking_export user should have been granted read, write privileges. It is here the dumpfiles are going to be created.
tables--> if the table is to be exported from another schema, then qualify it with the schema/user name
No comments:
Post a Comment