OraFAQ Forum: Server Utilities » Exporting two tables

Home » RDBMS Server » Server Utilities » Exporting two tables (oracle 10g)

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

Exporting two tables [message #334644]

Thu, 17 July 2008 09:16

ravi214u
Messages: 153
Registered: February 2008
Location: CANADA

Senior Member

hi,

I want to export two tables data into another data base tables .
It contains almost 4 lakh rows.
wat is optimum soln to export the tables.

thanks

Report message to a moderator

Re: Exporting two tables [message #334645 is a reply to message #334644]

Thu, 17 July 2008 09:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated above

Report message to a moderator

Re: Exporting two tables [message #334647 is a reply to message #334644]

Thu, 17 July 2008 09:26

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

EXPORT and IMPORT would seem to be made for your problem.

If you fancy being a bit techy about the whole thing, you could dump the data out to a file and use an External Table to load it back in again.

You could also look at DBMS_DATAPUMP

Report message to a moderator

Previous Topic:	Taking a backup in batches
Next Topic:	SQL loader issure with direct='Y'

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 11 07:58:04 CDT 2024