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

Home -> Community -> Mailing Lists -> Oracle-L -> Import Help!

Import Help!

From: Larry Taylor <ltaylor_at_iq.com>
Date: Mon, 4 Dec 2000 10:37:57 -0800
Message-Id: <10700.123552@fatcity.com>


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 Received on Mon Dec 04 2000 - 12:37:57 CST

Original text of this message

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