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.

Report message to a moderator

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: 2457
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

Report message to a moderator

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

Report message to a moderator

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: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

Previous Topic: What is the parameters of exp and imp command?
Next Topic: Load Data Submit Failed
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 11 05:33:34 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.