Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Import data in an other schema

Re: Import data in an other schema

From: Kekko <dini.f_at_adr.it>
Date: Wed, 25 Aug 1999 15:37:42 +0200
Message-ID: <37C3F1A6.C263F1B9@adr.it>


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 and
indexes=Y.
4. Drop the indexes owned by u.
5. Import the segments owned by u by specifyng full=N,rows=N,indexes=Y,indexfile=filename. 6. Edit filename, chenaging OLD with NEW. 7. Execute filename from SQL*Plus.

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US