importing..
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: importing..

  1. #1
    Join Date
    Nov 2002
    Posts
    115

    importing..

    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
    Prasad

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    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.

  3. #3
    Join Date
    Nov 2002
    Posts
    115

    importing..

    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
    Prasad

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width