RE: FULL EXP not create USER while IMP

Another way is to pre-create all the system objects (tablespaces, rbs, etc) and then do the import with INCTYPE=RESTORE, which skips the system objects altogether. Very nice.

-----Original Message-----
From: Istiqfar [mailto:istiqfar_at_yahoo.com] Sent: Friday, June 30, 2000 12:30 PM
To: Multiple recipients of list ORACLE-L Subject: Re: FULL EXP not create USER while IMP

This step is optional, just to make sure, that your tablespace is succesfully created. Creation will be failed in case you import into different machine with different directory structure. Failure in tablespace creation will cause failure in user creation if that failed tablespace is the default or temp tablespace of that user(s).

-istiqfar-

On Thu, 29 Jun 2000 13:24:50 -0700, you wrote:

|
| 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)
|
| Subject: Re: FULL EXP not create USER while IMP
|
|
|
|
| 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