Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Import data in an other schema
From the manual Oracle7 Administrator's Reference for UNIX page 3-12
TIP 15: Separate Index from Tables.
...
to move the indexes owned by user u from tablespace OLD into tablespace
NEW, perform the following steps:
1. Calculate the size needed to hold the indexes and create NEW. 2. Grant resource on NEW to u. 3. Export the segments owned by u by specifyng full=N,rows=N andindexes=Y.
Good Luck it's easy.
Kekko
Michel Dupont wrote:
> We have an instance et need to export data to another schema
> we export all user objects of the instance and make
> imp dest/dest fromuser =
> but all data are in the same tablespace (data and indexes) and we need
> different for each like in the original schema.
>
> Can we make import with data in data tablespace of the new schema
> and indexes in the index tablespace
>
> Thanks
Received on Wed Aug 25 1999 - 08:37:42 CDT
![]() |
![]() |