SOLVED - FULL EXP not create USER while IMP

the problem was solved by
creating the tablespaces and users before the full=y IMP

though this IS optional, but just to make sure that the IMP never get stuck anywhere, better to create tbs/users before doing a full=y IMP

Rahul

> ----------
> From: Miller, Jay[SMTP:JayMiller_at_TDWaterhouse.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Saturday, July 01, 2000 1:56 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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-----
> Sent: Thursday, June 29, 2000 5:36 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> 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
> also send the HELP command for other information (like subscribing).
> --
> Author: Miller, Jay
> INET: JayMiller_at_TDWaterhouse.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
Received on Sun Jul 02 2000 - 23:34:39 CDT