Re: FULL EXP not create USER while IMP

Normally there are (re)created while importing. You can see that by editing the DMP file.
If too big, you can EXP usr/pwd ROWS=N FILE=aaa.DMP

But I must say I a newcomer under version 8.1

HTH
Franck

|--------+----------------------->


|        |          Rahul        |

|        |          <rahul_at_rateli|

|        |          ndo.co.id>   |

|        |                       |

|        |          00-06-28     |

|        |          14:06        |

|        |          Please       |

|        |          respond to   |

|        |          ORACLE-L     |

|        |                       |

|--------+----------------------->
  >----------------------------------------------------------------------------|
  |                                                                            |
  |       To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>  |
  |       cc:     (bcc: Franck Vasseur/im/esa/ingerrand)                       |
  |       Subject:     FULL EXP not create USER while IMP                      |
  >----------------------------------------------------------------------------|

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: Rahul
  INET: rahul_at_ratelindo.co.id

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).