Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IMP question regarding Oracle schemas
Chuck wrote:
...
> tables in one tablespace and it's indexes in another tablespace. How
> can I import this schema into another database and segregate the
> tables and indexes into two different tablespaces? Or, should I export
> everything except the indexes, and then rebuild them in the new
> database?
I attached SQL script REB_IDX which do it automatically for all user
indexes.
All indexes move to tablespace TARGET_TABLESPACE:
plus80 user/pass_at_alias @reb_idx TARGET_TABLESPACE
2. Use import parameters INDEXES and INDEXFILE :
INDEXFILE - Specifies a file to receive index-creation commands INDEXES = N - skip index-creation commands
--