RE: FULL EXP not create USER while IMP

We had one problem on 8i last weekend doing a full export/import.

Apparently one schema (created by a third party app)was created with a CREATE SCHEMA command rather than a CREATE USER command (I didn't even know that was possible). After creating the user we were able to import the missing user. Could that have been the case for you?

-----Original Message-----
From: Winnie_Liu_at_infonet.com [mailto:Winnie_Liu_at_infonet.com] Sent: Thursday, June 29, 2000 5:36 PM
To: Multiple recipients of list ORACLE-L Subject: Re: FULL EXP not create USER while IMP

Isa,

No, you don't need to create the tablespaces manually at all if you are using the FULL=Y full database import.

Winnie

Istiqfar <istiqfar_at_yahoo.com> on 06/29/2000 08:29:21 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

Hi Rahul, better you check import log. Usually you *must* create all tablespace manually first before full import to make sure that statement "create user... default tbs ..." in dmp file was executed succesfully in import process.

I've tried full import in 8.1.x with no problem.

-isa-

On Wed, 28 Jun 2000 04:06:15 -0800, you wrote:

| List,
| i exported full from 7.3 and imported FULL=Y on 8.1.5
| it created all the tablespaces, but after that it
| stopped on ALTER SYSTEM SET SCHEMA...
| saying user does not exist...
|
| is there a way to import full with users also created ?
|
| TIA
|
| Rahul

--
Author: Istiqfar
  INET: istiqfar_at_yahoo.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).






-- 
Author: 
  INET: Winnie_Liu_at_infonet.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