Re: import/export/load in Oracle

you can avoid this bug to put all the name in uppercases

Erik
Oracle DBA Consultant

"Jim Kennedy" <kennedy-family_at_home.com> wrote in message news:<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 Thu Nov 08 2001 - 12:24:14 CET