Problem with Datapump Export
Posted on 2006-10-31
Hi, I am quite new to oracle, and have been playing with datapump feature. There is this specific problem that I have been struggling with for a while, and would appreciate any help.
I have no problem using expdp to export a whole database or a schema. However, I cant seem to be able to export individual tables.
I have created a user called BACKUP and have given the user IMPORT FULL DATABASE, EXPORT FULL DATABASE, SYSDBA system privilages. The user has the following roles: CONNECT, RESOURCE, EXP_FULL_DATABASE, IMP_FULL_DATABASE
I have a set of tables under another user called MYUSER. Tables are called Service_Table, and ActiveCodes.
If I try to export the whole MYUSER schema into a dump file, everything works fine. However, the problem I have is with exporting (or importing) individual tables. When I try to execute the following command:
expdp BACKUP/password TABLES="MYUSER"."Service_Table" DUMPFILE=tabledump.dmp
I get the following error
Starting "BACKUP"."SYS_EXPORT_TABLE_01": BACKUP/******** TABLES=MYUSER.Service_Table DUMPFILE=tabledump.dmp
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
ORA-39165: Schema MYUSER was not found.
ORA-39166: Object SERVICE_TABLE was not found.
ORA-31655: no data or metadata objects selected for job
Job "BACKUP"."SYS_EXPORT_TABLE_01" completed with 3 error(s) at 10:41:36
However I know that the MYUSER schema exists. As I mentioned. I have no problem importing, or exporting schemas. I have tried removing the double-quotes from around the table name, etc. but no luck
FYI I have oracle 10.2.0
I would be very grateful for any help