Re: Migration to Oracle

From: <meysam.khayatan_at_gmail.com>
Date: Mon, 3 Mar 2008 01:33:08 -0800 (PST)
Message-ID: <bf6c85f1-cda5-4079-913c-276d49dd1126@e6g2000prf.googlegroups.com>

Hi Morgan

> The best solution to your problem is to dump the SQL Server data as
> delimited ASCII, preferably not comma delimited, and then use SQL*Loader
> to get it into Oracle. It isn't a dumbed down GUI. Which is why it does
> such a phenomenally good job.

i think i don't understand what you say !!! your solution is for moving data to oracle. is this correct? so what about Tables,Views,Procedures,Functions,Trigger and ... . i should move first these objects then moving data. can i move these object to an Empty schema in my destination oracle database by Sql*Loader??

> Probably not because it is the wrong tool for the job.
SqlDeveloper as i think is a tool for Migration database? is this correct???

thanks alot
Best Regards Received on Mon Mar 03 2008 - 03:33:08 CST

This message: [ Message body ]
Next message: vijay: "Is there any way to know oracle connection is invalid when some one is trying to shutdown oracle service"
Previous message: Laurenz Albe: "Re: Ora 10.2.0.1, Error ORA-12514"
In reply to: DA Morgan: "Re: Migration to Oracle"
Next in thread: Serge Rielau: "Re: Migration to Oracle"
Reply: Serge Rielau: "Re: Migration to Oracle"
Reply: joel garry: "Re: Migration to Oracle"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message