chakryreddy
asked on
Sybase to Oracle data load.
Hi,
I would really appreciate it if someone would tell me how to load Oracle data(single table or an entire schema) to Sybase database.
Looking forward for an early reply.
Thanks,
Chakry
I would really appreciate it if someone would tell me how to load Oracle data(single table or an entire schema) to Sybase database.
Looking forward for an early reply.
Thanks,
Chakry
Export the Oracle data to a text file. Then use Sybase's bcp to load the data from that file. I'm not an Oracle guy, so you may have to check your documentation in how to export like that, but I can't believe it's that hard. You'll need to do this table-by-table.
Greg
Greg
Oracle's export is producing binary that is readable only by Oracle's import.
Idea is to use sqlplus to extract data to text file, with delimiter like "|" between fields, then import that using bcp in
Let me know
Idea is to use sqlplus to extract data to text file, with delimiter like "|" between fields, then import that using bcp in
Let me know
Oracle has no tools to export data out of its Databases (except in native format).
you can look at a commercial product
http://www.ispirer.com/products/
you can look at a commercial product
http://www.ispirer.com/products/
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you are running ASA instead of AS* try using the sa_migrate function. The other option is to set up a Remote server to the Oracle database and then suck the data across at will using SQL or the sa_migrate function.
ASKER