Home » RDBMS Server » Server Utilities » Export/Import Utilities
Export/Import Utilities [message #70144] Sat, 20 April 2002 10:54 Go to next message
Jayaram Alluri
Messages: 1
Registered: April 2002
Junior Member
Hi,
I have a question regarding the useage of Export / Import Utilities.
Say I have a user1 with two tables T1 and T2.
I have exported these two tables into a export file called both.dmp using the command
exp userid=system/manager tables=user1.T1 user1.T2 file=both.dmp
Now I want to import only table T1 from the export file to a new user user2???
Also can i excute this commnad as user1 also???
I was wondering how to go about it!!!!
Re: Export/Import Utilities [message #70146 is a reply to message #70144] Sun, 21 April 2002 18:53 Go to previous message
Cindy
Messages: 88
Registered: November 1999
Member
Try this:

imp system/manager file=scott.dmp fromuser=scott touser=blake tables=T1

More info:
http://technet.oracle.com/doc/server.815/a67792/ch02.htm#17270
Previous Topic: commit point reached
Next Topic: SQL query with search conditions to filter rows
Goto Forum:
  


Current Time: Fri Mar 29 07:05:27 CDT 2024