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
|
|
|
|
|
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
|
|
|
|
|
|
|
|
|