Home » RDBMS Server » Server Utilities » Import Utility
Import Utility [message #74036] Sat, 28 August 2004 08:58 Go to next message
Tzaperas
Messages: 5
Registered: August 2004
Junior Member
I imported usera's schema into userb and everything worked fine.  After I dropped usera, some of userb's tables are now missing. Is there a link between the users after the import ?

Import command:

imp system/<password> FILE=$ORACLE_BASE/admin/ORACLE_SID/backups/exp.full.dmp LOG=$ORACLE_BASE/admin/ORACLE_SID/logs/hpukg.imp.log BUFFER=30720 RECORDLENGTH=8192 FROMUSER=usera TOUSER=userb

Drop command:

drop tablespace usera_tables including contents;
drop tablespace usera_temp including contents;
drop tablespace usera_indexes including contents;
drop user usera cascade;
Re: Import Utility [message #74039 is a reply to message #74036] Sun, 29 August 2004 17:15 Go to previous messageGo to next message
rammohan
Messages: 13
Registered: March 2002
Junior Member
there could be two reasons for this.

1. you could have created userb's tables in usera's tablespace.

2. at the time of importing the referred tables would not have been imported. i.e. the grants will be given to userb, or userb may not be having sufficient space for the tables

rammohan
Re: Import Utility [message #74058 is a reply to message #74036] Wed, 01 September 2004 08:28 Go to previous messageGo to next message
Tzaperas
Messages: 5
Registered: August 2004
Junior Member
It is creating userb into usera's tablespace. Is there an export/import parm to override ? userb was created with it's own separate tablespace.
Re: Import Utility [message #74059 is a reply to message #74058] Wed, 01 September 2004 09:02 Go to previous message
Tzaperas
Messages: 5
Registered: August 2004
Junior Member
I found a link that has the steps to import into a different tablespace.

http://www.oracle.com/technology/oramag/oracle/02-jul/o42support.html
Previous Topic: Import Problem
Next Topic: Data Block corrupt
Goto Forum:
  


Current Time: Wed Dec 25 08:07:56 CST 2024