OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Import Utility

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import Utility [message #74036]

Sat, 28 August 2004 08:58

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;

Report message to a moderator

Re: Import Utility [message #74039 is a reply to message #74036]

Sun, 29 August 2004 17:15

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

Report message to a moderator