impdp-parameters Help [message #447665] |
Wed, 17 March 2010 03:56 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
goracle9
Messages: 136 Registered: December 2006
|
Senior Member |
|
|
Dear all,
i would like to import a table from another database by using databae link.
impdp muba/muba tables=FUNCTION_NO directory=testdump NETWORK_LINK=DBLINK1
i created the public database link as system user
it gave error like
Import: Release 10.2.0.1.0 - Production on Wednesday, 17 March, 2010 11:07:02
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production
Starting "MUBA"."SYS_IMPORT_TABLE_01": muba/******** tables=FUNCTION_NO directory=testdump NETWORK_LINK=DBLINK1
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 128 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-31685: Object type TABLE:"ITUSER"."FUNCTION_NO" failed due to insufficient privileges. Failing sql is:
CREATE TABLE "ITUSER"."FUNCTION_NO" ("FUNC_NO" VARCHAR2(5), "STRUCTURE" VARCHAR2(10), "DESCRIPTION" VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "PARTS"
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-39112: Dependent object type OBJECT_GRANT:"ITUSER" skipped, base object type TABLE:"ITUSER"."FUNCTION_NO" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"ITUSER" skipped, base object type TABLE:"ITUSER"."FUNCTION_NO" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"ITUSER" skipped, base object type TABLE:"ITUSER"."FUNCTION_NO" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"ITUSER" skipped, base object type TABLE:"ITUSER"."FUNCTION_NO" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"ITUSER" skipped, base object type TABLE:"ITUSER"."FUNCTION_NO" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"ITUSER" skipped, base object type TABLE:"ITUSER"."FUNCTION_NO" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"ITUSER" skipped, base object type TABLE:"ITUSER"."FUNCTION_NO" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"ITUSER" skipped, base object type TABLE:"ITUSER"."FUNCTION_NO" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"ITUSER" skipped, base object type TABLE:"ITUSER"."FUNCTION_NO" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"ITUSER" skipped, base object type TABLE:"ITUSER"."FUNCTION_NO" creation failed
ORA-39112: Dependent object type OBJECT_GRANT:"ITUSER" skipped, base object type TABLE:"ITUSER"."FUNCTION_NO" creation failed
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39112: Dependent object type TABLE_STATISTICS skipped, base object type TABLE:"ITUSER"."FUNCTION_NO" creation failed
Job "MUBA"."SYS_IMPORT_TABLE_01" completed with 13 error(s) at 11:07:11
after that i try to import as system user like
impdp system/passwd tables=FUNCTION_NO schemas=muba directory=testdump NETWORK_LINK=DBLINK1
but error like
Import: Release 10.2.0.1.0 - Production on Wednesday, 17 March, 2010 11:27:43
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.1.0 - Production
UDI-00010: multiple job modes requested, schema and tables.
when i use IMP utility
imp system/passwd file=dump.dmp fromuser=userA touser=userB log=dmplog.log
but when i use IMPDP what is the parameter equal to fromuser & touser
pls advide & clear my error plz.
|
|
|
|
|
Re: impdp-parameters Help [message #447678 is a reply to message #447673] |
Wed, 17 March 2010 05:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
This is just a link to a documentation, if you can access to web, you can access to it (unless you have restricted access to Oracle site).
And please DO NOT post in UPPER case.
Regards
Michel
|
|
|