OraFAQ Forum: Server Utilities » How to import data to new schema.

Home » RDBMS Server » Server Utilities » How to import data to new schema.

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

How to import data to new schema. [message #69096]

Tue, 30 October 2001 05:02

Ravi
Messages: 251
Registered: June 1998

Senior Member

I have changed the database schema by deleting some tables and adding some of the fields to another table.
Now I would like to import data from old schema to new schema. Could some one tell me how to do that? I would also like to know whether we can write a sql script for that.

I highly appreciate your help,

Thanx
ravi

----------------------------------------------------------------------

Report message to a moderator

Re: How to import data to new schema. [message #69099 is a reply to message #69096]

Tue, 30 October 2001 10:25

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

export tables using export utility and import to other schema using Import

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	Re: Ora-00942 :: Transferred data from SQL Server to Oracle Server.
Next Topic:	urgent!!!!!!!!!!!!!!!! calling sql loader from a sql procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 14:58:22 CST 2025