OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » EXPDP/IMPDP (oracle 10g windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

EXPDP/IMPDP [message #632406]

Fri, 30 January 2015 00:56

hdba
Messages: 16
Registered: January 2015
Location: INDIA

Junior Member

i am new to expdp/impdp topic

i want to export and import one table using datapump.

is it necessary every time create directory when ever we use datapump.

Report message to a moderator

Re: EXPDP/IMPDP [message #632407 is a reply to message #632406]

Fri, 30 January 2015 01:02

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is not but it is necessary to have one.

[Updated on: Fri, 30 January 2015 01:02]

Report message to a moderator

Re: EXPDP/IMPDP [message #632408 is a reply to message #632407]

Fri, 30 January 2015 01:08

hdba
Messages: 16
Registered: January 2015
Location: INDIA

Junior Member

ohk thanx a lot

i am facing one error here.

i create one user in sys scehma and in that user create one table with some data.

now when i am taking backup of this table using expdp i apply full=y and it gives follwing error.

ORA-39161: Full database jobs require privileges

Report message to a moderator

Re: EXPDP/IMPDP [message #632410 is a reply to message #632408]

Fri, 30 January 2015 01:15

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Full=y is not a tables export, it is a full database export which requires high privileges.
If you want to export a table then use "tables" parameter.

Note: "i create one user in sys scehma" this is meaningless. You create a user/schema, you don't create it in another schema.

Report message to a moderator