Home » SQL & PL/SQL » Client Tools » Export Data in nested table
Export Data in nested table [message #443794] Wed, 17 February 2010 06:20 Go to next message
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 messageGo to next message
cookiemonster
Messages: 12422
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 messageGo to next message
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
Re: Export Data in nested table [message #444829 is a reply to message #443794] Wed, 24 February 2010 07:13 Go to previous message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Datapump can definitely do data only - see the utilities guide
Previous Topic: Export dump of synonyms in a DB link
Next Topic: sqlplus error ORA-12154: TNS:could not resolve the connect identifier specified
Goto Forum:
  


Current Time: Sun Dec 11 02:18:34 CST 2016

Total time taken to generate the page: 0.22048 seconds