OraFAQ Forum: Server Utilities » exp/imp only data

Home » RDBMS Server » Server Utilities » exp/imp only data

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

exp/imp only data [message #254889]

Mon, 30 July 2007 00:14

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

Report message to a moderator

Re: exp/imp only data [message #254893 is a reply to message #254889]

Mon, 30 July 2007 00:18

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: exp/imp only data [message #254902 is a reply to message #254889]

Mon, 30 July 2007 01:00

martijn
Messages: 286
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.

Report message to a moderator

Re: exp/imp only data [message #254904 is a reply to message #254889]

Mon, 30 July 2007 01:02

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

Report message to a moderator

Re: exp/imp only data [message #254906 is a reply to message #254904]

Mon, 30 July 2007 01:09

Michel Cadot
Messages: 68664
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

Report message to a moderator

Re: exp/imp only data [message #254927 is a reply to message #254889]

Mon, 30 July 2007 01:41

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

Report message to a moderator

Re: exp/imp only data [message #255036 is a reply to message #254927]

Mon, 30 July 2007 08:20

joy_division
Messages: 4963
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.

Report message to a moderator

Re: exp/imp only data [message #255107 is a reply to message #254904]

Mon, 30 July 2007 11:32

Littlefoot
Messages: 21811
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.

Report message to a moderator

Re: exp/imp only data [message #255165 is a reply to message #255036]

Mon, 30 July 2007 22:23

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

What IM is?

Report message to a moderator

Re: exp/imp only data [message #255184 is a reply to message #255165]

Mon, 30 July 2007 23:46

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 22 22:13:27 CDT 2024