Home » RDBMS Server » Server Utilities » Import Tables
Import Tables [message #69018] Tue, 16 October 2001 08:47 Go to next message
Ibrahim
Messages: 16
Registered: October 2001
Junior Member
Hi all,

I have some tables in Access97 Database. I want to import these tables along with the data to Oracle8. I am new to Oracle and still in the SQL side. I know how to create tables and insert data using SQL Commands. I am looking for an easiest way to do the task.

Any help would be appreciated.

Regars,

Ibrahim

----------------------------------------------------------------------
Re: Import Tables [message #69019 is a reply to message #69018] Tue, 16 October 2001 13:08 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
export to flat file and load flat file data to oracle using SQLLOADER

----------------------------------------------------------------------
Re: Import Tables [message #69025 is a reply to message #69019] Wed, 17 October 2001 03:10 Go to previous messageGo to next message
Ibrahim
Messages: 16
Registered: October 2001
Junior Member
Suresh,

Thanks a lot for your response.

Could you pls give me an elaborated idea?

Thanks and Regards,

Ibrahim

----------------------------------------------------------------------
Re: Import Tables [message #69027 is a reply to message #69019] Wed, 17 October 2001 09:41 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
1)create flat file (text file) as comma delimited or fixed width format.
2) write a control file for each flat file
(sqlloader control file - should contain information about flat file name,format of data and
where to load etc.)
3) invoke SQLLOADER.

for more info : look into Oracle utilities documentation.

----------------------------------------------------------------------
Re: Import Tables - more [message #69028 is a reply to message #69027] Wed, 17 October 2001 09:43 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
1)create flat file (text file) as comma delimited or fixed width format (exporting data to text file)
2) write a control file for each flat file
(sqlloader control file - should contain information about flat file name,format of data and
where to load etc.)
3) invoke SQLLOADER.
for more info : look into Oracle utilities documentation.

----------------------------------------------------------------------
Previous Topic: How to solve this problem?
Next Topic: sequence numbers skipped when records are rejected during a load
Goto Forum:
  


Current Time: Thu Mar 28 21:21:36 CDT 2024