OraFAQ Forum: Server Utilities » export/dump with expdp for non-privileged users

Home » RDBMS Server » Server Utilities » export/dump with expdp for non-privileged users (10g)

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

export/dump with expdp for non-privileged users [message #555866]

Tue, 29 May 2012 09:26

oranooob
Messages: 88
Registered: May 2009

Member

Hi

We are DB users (not DBAs) and used always exp/imp bevore application upgrade.
Was googling arround and read something like "Oracle Data Pump - Time to let go of Exp / Imp". It seems exp/imp is obsolete.

Our system doesn't have "expdp" command

> find . -name expdp
>

is this because of too old SQL*Plus?

> sqlplus 
 
SQL*Plus: Release 8.1.7.0.0 - Production on Tue May 29 16:05:28 2012
 
(c) Copyright 2000 Oracle Corporation.  All rights reserved.
 
Enter user-name: ^C^C

additional questions:

- does our DBA need to give us privileges to run expdp/impdp?
- is that true that a expdp/impdp dump will be on the Oracle server (not the client machine)?

Report message to a moderator

Re: export/dump with expdp for non-privileged users [message #555867 is a reply to message #555866]

Tue, 29 May 2012 09:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>SQL*Plus: Release 8.1.7.0.0 - Production on Tue May 29 16:05:28 2012

expdp did not exist before V10 Oracle
you must use older, plain "exp" export utility

Report message to a moderator

Re: export/dump with expdp for non-privileged users [message #555869 is a reply to message #555866]

Tue, 29 May 2012 09:30

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>is this because of too old SQL*Plus?
To be precise,
it is because expdp is not available in this version of client/server you are using.
>>- is that true that a expdp/impdp dump will be on the Oracle server (not the client machine)?
The file will always be created in server.

Report message to a moderator

Re: export/dump with expdp for non-privileged users [message #555870 is a reply to message #555869]

Tue, 29 May 2012 09:37

oranooob
Messages: 88
Registered: May 2009

Member

Mahesh Rajendran wrote on Tue, 29 May 2012 09:30

>>is this because of too old SQL*Plus?
To be precise,
it is because expdp is not available in this version of client/server you are using.
>>- is that true that a expdp/impdp dump will be on the Oracle server (not the client machine)?
The file will always be created in server.

expdp is available on the server, but not client?

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0      Production
TNS for Solaris: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
 
SQL>

does the DBA need to give us privileges to run expdp? is expdp included in Oracle client? It means we need to upgrade Oracle Client?

Report message to a moderator

Re: export/dump with expdp for non-privileged users [message #555873 is a reply to message #555870]

Tue, 29 May 2012 09:47

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Quoting BlackSwan
Quote:

>SQL*Plus: Release 8.1.7.0.0 - Production on Tue May 29 16:05:28 2012

expdp did not exist before V10 Oracle

It is the version of client you are using.

Report message to a moderator

Previous Topic:	importing dumpfile
Next Topic:	sql loader error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 20:07:38 CST 2025