Re: Q: separate tables and indexes using imp

Zhijia Shen (shen_at_spot.Colorado.EDU) wrote:
: Hi,
: How do you separate tables and their indexes created
: internally by oracle for primary key constraints into
: different tablespaces using imp. I can separate the
: user created indexes by specifying the parameter
: INDEXFILE while doing imp, but this doe not seem
: have effect on the system created indexes.
: Thank you for your help.

You need to create all the tables with unique constraints (via DDL scripts or whatever) before the import. Explicitly create the tables in one TS and the unique constraint index in the index TS. On import, ignore the existing objects error and it should populate using the DDL you've already placed.

Joe

-- 
                                   
=------------------------------------------------------------------------=
Joe Nardone               |    
joe_at_access.digex.net      |