OraFAQ Forum: Server Utilities » sql command to take export of the tables and data of the tables at user level with examples

Home » RDBMS Server » Server Utilities » sql command to take export of the tables and data of the tables at user level with examples (i need to export the all the tables in a particular user and data in that tables)

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

sql command to take export of the tables and data of the tables at user level with examples [message #273890]

Fri, 12 October 2007 02:06

novice1
Messages: 15
Registered: September 2007

Junior Member

Hi ,

I need to create a sql script to take user level back up i.e i need to export the tables and data in those tables in particular user) to my pc..

i am able to do the same from unix command ,but not able to do the same in sql script

Please advice.

Report message to a moderator

Re: sql command to take export of the tables and data of the tables at user level with examples [message #273897 is a reply to message #273890]

Fri, 12 October 2007 02:55

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

There is no difference between Unix and PC.
What is your problem?

Regards
Michel

Report message to a moderator

Re: sql command to take export of the tables and data of the tables at user level with examples [message #273922 is a reply to message #273897]

Fri, 12 October 2007 04:33

novice1
Messages: 15
Registered: September 2007

Junior Member

Hi,

From Sqlplus i need to run only a sql file, that contains the code to export the user tables and data in the table from to my pc.

for example.

we can give the below code directly fro cmd prompt and it does the work.
exp oper/oper@webcen PARFILE=params.dat

but how can i give this command in a sql script .we cannot give it gives error.

My Os is windows and oracle database is 10g

please advice.

Report message to a moderator

Re: sql command to take export of the tables and data of the tables at user level with examples [message #273930 is a reply to message #273922]

Fri, 12 October 2007 04:52

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

exp is not a SQL*Plus command it is an OS one.
You have to do it at OS prompt.

By the way, telling "it gives error" does not help us to find the reason. If Oracle gives an error message maybe it is useful, so maybe it is useful you post it.

Regards
Michel

Report message to a moderator