Import/Export to Oracle

[rpk2006]

When I use Import/Export feature of SQL Server 2000 to migrate SQL Server 2000 database to Oracle, SQL Server converts all table names to something like this:
"table name", instead of just table names without any quotes.

Because of this when the tables are successfully migrated to Oracle and when I run SQL Query, I have to use like this:

Select * from "table name"

instead of simply,

Select * from table name.

What's the problem? Why SQL Server includes double quotes with the table names and how to get rid of this?

 

[dbomrrsm]

Select * from table name will bring nowt back - you cant have spaces in table names unless you put them in []

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[mrdenny]

After you select the tables to copy, check in the transformations buttons. The script to create the table should be there. Make sure it has no " in it. Do your table names have spaces in them?

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[SantaMufasa]

Just to clarify, in Oracle, so long as you name an object within double quotes (which I do not recommend), you can use any character(s) you wish:

SQL> create table " " (" " varchar2(20));

Table created.

SQL> insert into " " values ('This is a test.');

1 row created.

SQL> select * from " ";


--------------------
This is a test.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 20:01 (23Feb05) UTC (aka "GMT" and "Zulu"),
@ 13:01 (23Feb05) Mountain Time

Do you use Oracle and live or work in Utah, USA? Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[rpk2006]

My Table Names are of single words and there is no question of giving spaces between words.

In the Transformation Button in 'Import/Export' wizard of SQL Server 2000, I tried removing "", but it displayed error and insisted of using "".

If you Import Oracle database to SQL Server, then the 'Import/Export' Wizard changes the SQL Server names to something like this:

[TableName]

 

[dbomrrsm]

in the DTS wizard the table name is surrounded by [] but when you look at the table following the import - as long as there are no spaces in the table name the [] will not be present in the name.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[Joeybear23]

Is this a one-time export, or a regular process?

If it is just a one-time conversion and there are not many tables, you can create the tables in Oracle, then load the tables with the import/export wizard.



SQL/SAP DBA