Home » Other » General » Data conversion from Sqlserver to Oracle
Data conversion from Sqlserver to Oracle [message #365175] Thu, 22 June 2000 15:04
Venu
Messages: 44
Registered: September 1999
Member
I have 10 tables in Sql Server and I want to bring them to Oracle with data. Is there a way to do it..
I don't have any data conversion tools.
Thanks
Venu
Re: Dropping a column [message #365190 is a reply to message #365175] Thu, 02 April 1998 15:16 Go to previous message
Konda
Messages: 1
Registered: April 1998
Junior Member
Hi ,
Create a table and select all the data from the original table.. by using this script..
"CREATE TABLE TEMP as
(SELECT COL1,COL2...... FROM ORIGINAL_TAB) "
Your Table will be created based on the columns u have selected... then delete or rename your ORIGINAL table as something , and rename the TEMP table as ORIGINAL...
...
Previous Topic: Thierry Van der Auwera-Where are you?-Oracle won't start.
Next Topic: Barcode
Goto Forum:
  


Current Time: Fri Feb 03 14:22:12 CST 2023