OraFAQ Forum: Server Utilities » Urgent -- Import/Export

Home » RDBMS Server » Server Utilities » Urgent -- Import/Export

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

Urgent -- Import/Export [message #72461]

Mon, 23 June 2003 21:48

Nitin
Messages: 35
Registered: July 1999

Member

Hi,
I want have to export a table in database to another database ( the table structure are different).
which is the best and fast method to do as the data would be in millions.

Report message to a moderator

Re: Urgent -- Import/Export [message #72463 is a reply to message #72461]

Tue, 24 June 2003 05:49

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

1. rearrange the table in the source itself to look like the one in target.
   something like,
   create table new_table as select c1,c3,c2,c6,c4,c5 
   from original_table.
2. now export this table and import it into target

Report message to a moderator

Previous Topic:	Oracle Export/Import & security
Next Topic:	Options to transfer data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 08:04:15 CST 2024