Export Data in nested table [message #443794] |
Wed, 17 February 2010 06:20 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sandrino82
Messages: 6 Registered: February 2010
|
Junior Member |
|
|
Hi, I have some problem when i try to export data from a table which contains a nasted table, using toad.
When toad generate the file, in the column corresponding to the nested table, toad just write a (DATASET) instead of the data contained in the nested table
Here is an example:
INSERT INTO SSD_REV_S ( REV_ID, REV_TAB, REV_TS, REV_USER, REV_LOG )
VALUES (
TO_Date( '07/30/2007 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), (DATASET), TO_TIMESTAMP('4/3/2009 11:20:51.000000 AM','fmMMfm/fmDDfm/YYYY fmHH12fm:MI:SS.FF AM'), 'operator', 'Add EVENT');
REV_TAB is my nested table
Can anyone tell me a good way to export data froma table which contain a nested table, as a list of insert statement, so i can move the data to a different database schema? I can also use different client tool,so any help will be appreciated
|
|
|
Re: Export Data in nested table [message #443796 is a reply to message #443794] |
Wed, 17 February 2010 06:26 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13938 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Why not just use oracles own import/export tools?
They'll cope with nested tables.
If you're moving the data to a different schema in the same db why not just do a straight insert/select.
|
|
|
Re: Export Data in nested table [message #444795 is a reply to message #443796] |
Wed, 24 February 2010 04:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sandrino82
Messages: 6 Registered: February 2010
|
Junior Member |
|
|
I'm moving the data to a different database, and i have many tables, so inserting/selecting statement would not be praticalfor me.
i am trying to use the import/export utilities, but i have some problems usinf the oracle enterprise manager console(it crash every time i insertusername and password toconnect to the db schema).
Is it possible using export tool, exporting only data contained in the tables? i don't wanto to export also database objects (like tables, sequences and so on....)
Regards
Alessandro
|
|
|
|