OraFAQ Forum: Server Utilities » can i import a table into db1 from an export file of db2?

Home » RDBMS Server » Server Utilities » can i import a table into db1 from an export file of db2?

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

can i import a table into db1 from an export file of db2? [message #368107]

Wed, 19 July 2000 22:20

Linda
Messages: 22
Registered: July 2000

Junior Member

I want the content of table1 of database1 to be inserted into table1 of database2,so i export it from database1, and then import the exportfile into database2, but not success, is it possible to do that?

Report message to a moderator

Re: can i import a table into db1 from an export file of db2? [message #368110 is a reply to message #368107]

Fri, 28 July 2000 12:23

Sam
Messages: 255
Registered: April 2000

Senior Member

Is it belongs to same schema? Other wise you have to use fromuser / touser clause....

try out all the best
sam

Report message to a moderator

Previous Topic:	O8i EXP(NT)/IMP(Solaris) problems
Next Topic:	SQL-Loader 524: Partial record found

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 21:49:25 CST 2025