import/export/load in Oracle

From: hands <jordanc_at_symtron.com.tw>
Date: Fri, 2 Nov 2001 10:40:53 +0800
Message-ID: <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 - 03:40:53 CET

Original text of this message