Import Tables [message #69018] |
Tue, 16 October 2001 08:47 |
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 #69025 is a reply to message #69019] |
Wed, 17 October 2001 03:10 |
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 |
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 |
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.
----------------------------------------------------------------------
|
|
|