This content has been marked as final. Show 3 replies
How about pre-create the tables in their tablespaces then import just the data?
generate all the DDL for the tables. Put the tables in the tablespaces in the new database with the compression, then you can just import the data.
that is pretty much option 3 you are suggesting, no?
i'm creating a sqlfile with metadata only, but i have to remove the uncompress keyword from that file since table properties overrides the tablespace properties.
I was looking for an easier way, but maybe i just have to do it that way.
Yes, sinilar to option 3, however I believe that you can script the meta data extract eliminating the need to modify