| SQL loader and sybase [message #171288] |
Tue, 09 May 2006 05:19  |
pulkit_a
Messages: 50
Registered: December 2005
|
Member |
|
|
Hi,
I have to extract some data from sybase tables into oracle tables which have exactly the same structure as sybase tables have.
Is it possible to load data directly from sybase database tables to oracle tables using sqlloader without the data files.
Thanks
Pulkit
|
|
|
|
| Re: SQL loader and sybase [message #171312 is a reply to message #171288] |
Tue, 09 May 2006 06:56  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
No, it is not possible. You need to somehow extract the Sybase data into files. Then, use SQL*Loader to load the data into Oracle.
PS: Oracle Migration Workbench might be able to help you with this (not sure - but it may be worth a try).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
