Storage while importing tables
Is there any way to import tables without their default storage settings? I need to import few tables, but I want those tables to use default storage setting of tablespace and not of their default storage.
That's a good one, I'm not sure. I think you could import the DDL and then spool a alter script to get the storage to match the tablespace default. Then import you data, that may work.
I remember when this place was cool.
another suggestion :
import to an indexfile.
alter storage for objects.
create objects using indexfile.
Import data only (ignore errors).
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
Before that I though If I import into another tablespace and later moved to the required tablespace, then it might take the new tablespace storage parameters.. but it doesn't change defaults...
Bit of tedious job of editing storage parameters. But thanks a lot.. it did the required.
Click Here to Expand Forum to Full Width