import a full dump file
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: import a full dump file

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Location
    Duluth, Georgia, USA
    Posts
    99

    Question

    Hi,

    Before I import a full dump file (the export was done by system user) as system user, do I need to know which users I need to create manually in order to import data belonging to those users or the import utility will automatically create necessary users and/or other things?

    Thanks,

    Jiong

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    if its a full database export oracle will create all the users in the database...if its a schema dump you need to know to which user you want the database to dumped...

    regards
    anandkl
    anandkl

  3. #3
    Join Date
    Dec 2001
    Location
    Duluth, Georgia, USA
    Posts
    99
    Hi anandkl,

    So I just create a new database instance, and then import as system user? The import utility knows what should be created and will not give 'users not existed' error?

    Thanks,
    Jiong
    Jiong
    ---------------------------
    OCP (DBA 8, 8i, 9i, AD, iAD)
    SCSA, SCJP, SCWCD
    ---------------------------

  4. #4
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    what exactly u want , u want schema users dump or full database dump.

    U can use the parameter show=y in import to see the contents of the export dump file u have .

    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  5. #5
    Join Date
    Dec 2001
    Location
    Duluth, Georgia, USA
    Posts
    99
    Hi,

    I did some test and when importing a full dump file, it doesn't need to create users.

    Thanks,
    Jiong

  6. #6
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    Are the tablespace name same in the instance where u want to import it.

    As long as the tablespace exist full database dump will create the users.

    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  7. #7
    Join Date
    Apr 2002
    Posts
    55


    A question that sometimes drives me hazy: am I or are the others crazy?

    VenDe ChukPeen Zuri

    Someone who quotes himself as a DBA and posts simple question in forums is a big idiot to me . I donot care what others think

  8. #8
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Jiong, Could you please paste your imp command. Full import should create all the users in dmp file.

    And vendechukp, please refrain from distracting the main discussion.
    -- Dilip

  9. #9
    Join Date
    Dec 2001
    Location
    Duluth, Georgia, USA
    Posts
    99
    Hi Dilip,

    Below is how the import is going:

    $ imp

    Import: Release 8.1.6.0.0 - Production on Wed Jul 3 11:40:25 2002

    (c) Copyright 1999 Oracle Corporation. All rights reserved.

    Username:
    Password:

    Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.6.0.0 - Production

    Import file: expdat.dmp > data_c.dmp

    Enter insert buffer size (minimum is 8192) 30720>

    Export file created by EXPORT:V08.01.06 via direct path

    Warning: the objects were exported by SYSTEM, not by you

    import done in US7ASCII character set and US7ASCII NCHAR character set
    List contents of import file only (yes/no): no >

    Ignore create error due to object existence (yes/no): no >

    Import grants (yes/no): yes >

    Import table data (yes/no): yes >

    Import entire export file (yes/no): no >
    Username:

    Enter table(T) or partition(T:P) names. Null list means all tables for user
    Enter table(T) or partition(T:P) name or . if done:

    . . importing table

    .
    .
    .

    .
    .
    .


    IMP-00009: abnormal end of export file
    IMP-00028: partial import of previous table rolled back: 1835351 rows rolled bac
    k
    Import terminated successfully with warnings



    Also, I checked the alert.log file under bdump and found the following error:

    ARC0: media recovery disabled
    Thread 1 cannot allocate new log, sequence xxx
    Checkpoint not complete

    Is this something with archivelog mode? I checked the instance and it has ARCHIVE started. However, under the directory where the archivelog files are supposed to store, there is no file there.

    Anyway, I am still investigating this. I would appreciate any opinion or suggestion from you.

    Jiong

  10. #10
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    yes when it says that whether u want to import the entire export file u have said NO.

    Then secondly when u said NO for the entire export file u it asked u username there also u have kept it blank.

    Thirdly when it prompted for table , u should have entered table names. There also u have put it blank.

    If u want to import the entire dump u should say YES in the parameter import entire file.

    As i said ealier that as long u have tablespaces created in your new instance a full import will create users fro u.






    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

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