Re: import/export/load in Oracle
Date: Fri, 02 Nov 2001 03:25:23 GMT
Message-ID: <DmoE7.5765$Tb.3078005_at_news1.sttln1.wa.home.com>
The msSQL tool creates the tables in "'s so the table name and columns etc
are all in mixed case. (Yech)
The tool basically did a create table "myTable"("Col1" number....) and so
select * from mytable or myTable won't work.
You have to do select * from "myTable";
Or don't use the export tool. and do it another way.
Jim
"hands" <jordanc_at_symtron.com.tw> wrote in message
news:9rt0gs$1qjl$1_at_news.is.net.tw...
> Dear All,
>
> I got some questions, can someon help me ?
>
>
> Question 1:
> I run into the big issue about the import/export data from the existing
> database. I have some tables in MSSQL and I trying to export them to
Oracle
> database by using MSsQL export tool. I found they were imported into
Oracle
> database, but when I use SQL*plus to select * table_name, then I always
see
> table name is incorrect. I use the OEM to check data, I can see data. Do I
> have anything wrong? Or should I check something else?
>
> Question 2, how do I use the Import, Export and Load tool to import from
> Oracle OEM? I checked it and found it is very strange. I have no idea of
> using them.
>
> Question 3, After the table or field name I had created, can I modify it
> from OEM?
>
>
> Thanks,
> Jordan
>
>
Received on Fri Nov 02 2001 - 04:25:23 CET