can i change the owner of a table

[bookouri]

I need to do schema export. It takes a couple of hours to do the export but most of that export is one very large table of images stored as long raws. For this project I dont need the images table. There are several hundred other tables in the schema though so I dont want to export tables=tab1, tab2, tab3 etc, i need to export the schema but without the images table. since I cant exclude the image table in the export, can i temporarily change the owner of the table so its not picked up by the export schema?

any suggestions would be appreciated.

 

[stefanhei]

When I'm asked to do something like your request I usually create a list of all but that one tables of that schema:

SELECT table_name||',' from user_tables
where table_name != 'THAT_ONE_TABLE'

and spool the output to a file which I edit (delete the last colon, put in parantheses,...) and use it as a commandfile for exp.

 

[bookouri]

Do you know if there is any problem with exp if there happens to be several hundred tables in that list? I think theres over 400 tables in the schema.

 

[stefanhei]

I had no problems with 285 - 2 tables and never heard about a problem with more.