importing..

[prasadvd]

Hi,

I have a problem when i try to import a dump file which is full export into same user.

>imp system/pwd file=e:\logiback\expdat2.dmp log=e:\expdat2.log
fromuser=compile touser=compile rows=y

it says :
===========

Export created by Export:v08:01:05 by direct path
import done in we8is08859p1 character set and we8is08859p1 nchar set
c:>

I could not be able to get the data into user.


An immediate solution is appreciated.

prasadvd@rediffmail.com

[stecal]

A problem arises when you just want to use the full database export to import only certain schemas in order to preserve their passwords and any privileges granted to them, but these DO NOT own any objects yet (i.e., these users have not yet created any objects in their schemas). Although the necessary DDL information to recreate these users and their grants exists in the full database export file (i.e., you can see this if you do the following from a OS prompt: imp userid=system/manager file=full.dmp log=full.log full=y show=y), these users 'WILL NOT GET CREATED IF YOU DIRECT AN IMPORT USING THE "FROMUSER" PARAMETER -- THIS PARAMETER DIRECTS ORACLE TO DO A USER-LEVEL IMPORT AND BY DEFINITION, A USER-LEVEL IMPORT ASSUMES THAT THE USERS EXIST AND ONLY EXPECTS TO IMPORT SCHEMA OBJECTS.

[prasadvd]

Hi Steve,

You just give me clearly what should i do now to import into user
"COMPILE" from full exported file ?




Awaiting for ur reply
prasadvd@rediffmail.com