Hi,
There is no need to do 2 exports. Just perform one export with data. Run
import with indexfile= option to get a ddl for rebuilding the objects. Edit
the ddl file for tables and indexes (I split it into two files, one for
tables and other for indexes) to create them in proper tablespaces and with
proper storage clause. Set quota to 0 on all unwanted tablespaces for the
schema owner. Run the table creation ddl to build all the table with no data
in proper tablespaces. Next, run import with ignore=y, commit=y options to
get the data in.
Hope this helps..
- Kirti
> -----Original Message-----
> From: April Sims [SMTP:simsa_at_acu.edu]
> Sent: Wednesday, October 18, 2000 2:02 PM
> To: ORACLE-L_at_fatcity.com; oracledba_at_lazydba.com
> Subject: Moving data from one db to another
>
> Hello all,
>
> Need some advice. Moving a database from 7.3.4 to 8.1.6
> This database really needs to be cleaned up.
> What is the best way to do this?
> Want to move objects to a differently named tablespace, reclaim lost
> space,
> etc.
>
> This is what is planned-
> Create users in new database with default tablespaces assigned.
> 1. Export without data by schema - expschema.dmp
> 2. Import expschema.dmp which will put the objects in the correct
> tablespace.
> 3. Export again by schema with data - expschema_data.dmp
> 4. Import expschema_data.dmp
>
> Will this do what I want?
>
> Thanks for any advice.
>
>
>
>
> >>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<
> April Sims MCSE, CNE Abilene Christian University
> Database Administrator ACU Box 29005
> Information Technology Abilene, TX 79699
> simsa_at_acu.edu Vx:(915)674-2681 Fx:674-6724
> >>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<
>
>
>
> --------
> Think you know someone who can answer the above question? Forward it to
> them!
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
Received on Wed Oct 18 2000 - 14:20:21 CDT
