RE: Import Help!

Larry,
You're on the right path by using import's fromuser/touser parameter. If you want to import the objects into different tablespace then you might want to
1). set default tablespace of the "touser" to the correct tablespace 2). alter "touser" quota 0 ON <the fromuser's tablespace>.

The other method to do this is to pre-create all the objects in the correct tablespace before you perform the import (don't forget to specify ignore=y)

HTH.....
- Sah Kohsuwan

-----Original Message-----
From: Larry Taylor [mailto:ltaylor_at_iq.com] Sent: Monday, December 04, 2000 1:41 PM
To: Multiple recipients of list ORACLE-L Subject: Import Help!

Hi all,

I've imported all the objects from one user(schema) to another user, but the the idexes were'nt and objects were imported back into the from user's tablespace,
why? This was done in 8.1.6. database.

Here's what I did:

exp system/sysman file=tank.dmp log=tank.log owner=tank

imp system/sysman fromuser=tank touser=tank_copy file=tank.dmp log=tank_copy.log

Do you have any suggestions on how to import all the objects from one user to another?

Thanks
Larry

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Taylor
  INET: ltaylor_at_iq.com

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
also send the HELP command for other information (like subscribing).




"WorldSecure Server <baking.bestfoods.com>" made the following

 annotations on 12/04/00 16:46:19
----------------------------------------------------------------------------
-
The origin of this electronic mail message was the Internet.
Bestfoods Baking cannot validate the authenticity
of the sender and therefore cannot be held accountable
for any content within.
=======================================================





"WorldSecure Server <baking.bestfoods.com>" made the following

 annotations on 12/04/00 16:56:48
-----------------------------------------------------------------------------
This message may contain confidential and trade secret information of Bestfoods Baking, and be subject to the Economic Espionage Act of 1996. For recipient's use only. If you have received this message in error, please delete immediately, and alert the sender.