Home » RDBMS Server » Server Utilities » export/dump with expdp for non-privileged users (10g)
export/dump with expdp for non-privileged users [message #555866] Tue, 29 May 2012 09:26 Go to next message
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)?
Re: export/dump with expdp for non-privileged users [message #555867 is a reply to message #555866] Tue, 29 May 2012 09:28 Go to previous messageGo to next message
BlackSwan
Messages: 26757
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
Re: export/dump with expdp for non-privileged users [message #555869 is a reply to message #555866] Tue, 29 May 2012 09:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
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.
Re: export/dump with expdp for non-privileged users [message #555870 is a reply to message #555869] Tue, 29 May 2012 09:37 Go to previous messageGo to next message
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?
Re: export/dump with expdp for non-privileged users [message #555873 is a reply to message #555870] Tue, 29 May 2012 09:47 Go to previous message
Mahesh Rajendran
Messages: 10694
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.
Previous Topic: importing dumpfile
Next Topic: sql loader error
Goto Forum:
  


Current Time: Thu Jan 21 12:03:04 CST 2021