Home » RDBMS Server » Server Utilities » impdp-parameters Help (oracle 10.2.0.1.0,Redhat Linux 4)
impdp-parameters Help [message #447665] Wed, 17 March 2010 03:56 Go to next message
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 #447668 is a reply to message #447665] Wed, 17 March 2010 04:11 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
You can read this one more time...

Database Utilities
All your Questions were answered here

sriram
Re: impdp-parameters Help [message #447673 is a reply to message #447668] Wed, 17 March 2010 04:51 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
sORRY RIGHTNOW I DONT HAVE DOWNLOAD OPTION TO VIEW THE PAGE WHITCH YOU GAVE

please MR.MICHEL ASNWER ME
Re: impdp-parameters Help [message #447678 is a reply to message #447673] Wed, 17 March 2010 05:41 Go to previous message
Michel Cadot
Messages: 64102
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
Previous Topic: What is the parameters of exp and imp command?
Next Topic: Load Data Submit Failed
Goto Forum:
  


Current Time: Fri Dec 02 14:32:00 CST 2016

Total time taken to generate the page: 0.14976 seconds