Easy Import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Easy Import

  1. #1
    Join Date
    Oct 2000
    Posts
    32
    Hi.

    Okay, first, thanks for your time.

    Here is my situation:

    I am running Ora8i...new install.

    Need to perform full import.

    I am an assistant to a db programmer.

    I have a cd with a full .dmp file.

    When I read all about importing, it seems as though it would be relatively easy to import this full database so that we can have it locally. Not too much DBA tasks once it is loaded, right?

    I haven't really tried importing with the gui wizard. I have tried with the command prompt. Successfully. I just can't find it once it is imported. I get errors that say: 'user does not exist' and 'object already exists'

    I am wondering if my parameters are correct. Basically, I need to do a full import. Is this possible?

    This what I currently use to import:

    imp system/password@db file=path.dmp full=y log=filename.log

    Do I need to create a db to import into with no parameters? An empty db with no tablespaces or anything? I currently import to a db that I created with the gui...it might be a "typical" db?

    Sorry for rambling and not knowing much of anything, really. I simply need to import this database. I have read so much on importing. I think what I am trying to do should be simple. I am missing something, can you help?

    Thanks,
    Rara.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    if you do full=y, in your new database you dont need anything other than tablespace system, full will import all users, tablespaces, objects privileges etc etc.

  3. #3
    Join Date
    Oct 2000
    Posts
    32
    That is what I thought...so, do I create a db with no tablespace or users or anything to import into???
    Thanks,
    Rara.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    yeap right, make sure itīs empty with only tablespace system and data dictionary

  5. #5
    Join Date
    Oct 2000
    Posts
    21
    While creation a db, a system t'space and system rollback seg will automatically be created.
    Rest of the things will be taken care by ur IMP statement. The full=y will create all the other
    relevent objects
    Pao de dabba
    B'ham

  6. #6
    Join Date
    Oct 2000
    Posts
    32
    But, shouldn't I be creating a db with no tablespace parameters? When I import, I get errors of objects that already exist.

    Also, can I do this without using the gui? I don't feel comfortable with the gui. Or, should I just use the gui and do a custom creation with no parameters?


    I haven't done this before.
    Thanks,
    Rara.

  7. #7
    Join Date
    Jan 2000
    Location
    Silver Spring MD USA
    Posts
    105
    Pao's right, the full import will create tablespaces for you, but only if those tablespaces can be created in the same directory as the source database. If you know for sure that the tablespaces can be created in the same directories as the original database, then I would create System, rollback segment and temp tablespaces and let the import do the rest.

    However, if you're not sure if the tablespaces should be created in the same directories as the source database, or if you know for sure that they will be different, then I would create all the target tablespaces in the directories I want them to be in first, grant quota to the tablespaces for the user doing the import, then do a full import. If the import sees that the tablespaces already exist, it will create the objects in the correct tablespaces. In this case, add the parameter, ignore=y. This will skip over errors, "object already exists."

    In the past, I have had to create users and roles in the database before the import to avoid the "user does not exist" errors. But there where other times this was not necessary.

    Good luck.
    maachan

  8. #8
    Join Date
    Oct 2000
    Posts
    21
    maachan's 2nd para reveals the perfect way....
    Pao de dabba
    B'ham

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