RE: Moving data from one db to another

Sims,

In the 2nd step, you will import into the same tablespaces.

If you want to move the objects in to different tablespace, you need to create the empty objects in to the new tablespace. You may use INDEXFILE option of import command to create the script that consists of only the structure. Edit the file and create the objects you want into the new tablespaces. Make sure that you grant the quota on the new tablespace to the schema owner of the tables.

Use ignore=y option when importing the data.

While importing, it would import by consolidating all the extents into one single extent. It would eliminate the fragmentation. After importing change the next extent sizes and pctincrease values of the objects sothat it won't fragment again.

You may use full DB export instead of schema wise export, in this case.

Goodluck

• Janardhana Babu

-----Original Message-----
From: April Sims [mailto:simsa_at_acu.edu]
Sent: Wednesday, October 18, 2000 1:01 PM To: Multiple recipients of list ORACLE-L 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-
 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


 >>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: April Sims
  INET: simsa_at_acu.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may