Home » RDBMS Server » Server Utilities » How to import data to new schema.
How to import data to new schema. [message #69096] Tue, 30 October 2001 05:02 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 21:57:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.