Home » RDBMS Server » Server Utilities » exp/imp only data
exp/imp only data [message #254889] Mon, 30 July 2007 00:14 Go to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Hi
I wanted to export only data from a table(say scott's emp table's data),then wanted to import into another user's (say hr's emp table).what is the systax ?.[same table structure exist on both users]

I tried with the following systax ,but I couldn't import

c:\>exp scott/tiger@orcl tables=emp file=d:\exp_emp.dmp rows=y indexes=y constraints=y grants=n statistics=none

c:\>imp hr/hr123@orcl file='d:\exp_emp.dmp' fromuser=scott touser=hr

by
sbmk_design
Re: exp/imp only data [message #254893 is a reply to message #254889] Mon, 30 July 2007 00:18 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>but I couldn't import
My car couldn't go. Tell me how to make my car go.
Re: exp/imp only data [message #254902 is a reply to message #254889] Mon, 30 July 2007 01:00 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
Maybe you can post your error messages etc. At the moment it can be numerous thing that wend wrong.
Re: exp/imp only data [message #254904 is a reply to message #254889] Mon, 30 July 2007 01:02 Go to previous messageGo to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
sorry Mr.anacedent
The above one is table level export/import.
In oracle is there any option data level exp/imp ? I wanted to export/import only rows.

by
sbmk_design
Re: exp/imp only data [message #254906 is a reply to message #254904] Mon, 30 July 2007 01:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You always export table description with data.
To export only part of data have a look at the "query" parameter.

Regards
Michel
Re: exp/imp only data [message #254927 is a reply to message #254889] Mon, 30 July 2007 01:41 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

U can also use data pump export/Import if u have version above 9i. In data pump import a option
table_exists_action=append
.
Or
content=data_only
Re: exp/imp only data [message #255036 is a reply to message #254927] Mon, 30 July 2007 08:20 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Please stop using IM speak. You have close to 200 messages now, you should be a little more professional.
Re: exp/imp only data [message #255107 is a reply to message #254904] Mon, 30 July 2007 11:32 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Umm ... is it perhaps the IGNORE=Y that your IMP command misses?
C:\TEMP>exp scott/tiger tables=dept file=dept.dmp

About to export specified tables via Conventional Path ...
. . exporting table                           DEPT          4 rows exported
Export terminated successfully without warnings.



C:\TEMP>imp mike/lion file=dept.dmp ignore=y fromuser=scott touser=mike

Warning: the objects were exported by SCOTT, not by you

import done in EE8MSWIN1250 character set and AL16UTF16 NCHAR character set
. importing SCOTT's objects into MIKE
. . importing table                         "DEPT"          4 rows imported
Import terminated successfully without warnings.
Re: exp/imp only data [message #255165 is a reply to message #255036] Mon, 30 July 2007 22:23 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
IM


What IM is?
Re: exp/imp only data [message #255184 is a reply to message #255165] Mon, 30 July 2007 23:46 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Just read below article on IM Speak !!!

http://tkyte.blogspot.com/2006/01/im-speak.html


Regards
Taj
Previous Topic: export LOB and CLOB from one to another database
Next Topic: update through sql loader
Goto Forum:
  


Current Time: Sat Dec 10 20:28:35 CST 2016

Total time taken to generate the page: 0.11969 seconds