OraFAQ Forum: General » Data conversion from Sqlserver to Oracle

Home » Other » General » Data conversion from Sqlserver to Oracle

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

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

Report message to a moderator

Re: Dropping a column [message #365190 is a reply to message #365175]

Thu, 02 April 1998 15:16

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...
...

Report message to a moderator

Previous Topic:	Thierry Van der Auwera-Where are you?-Oracle won't start.
Next Topic:	Barcode

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

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