Import
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Import

  1. #1
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Hi all,

    I want to touch the age old issue of Export/Import of Oracle databases. I am trying to import from a data dump - both the source & destination are of Oracle 816 and when I run my import command, this is the output I get :

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

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

    import done in US7ASCII character set and US7ASCII NCHAR character set
    Import terminated successfully without warnings.
    "
    I do not get any error messages, but no objects have been imported. Is this due to the character set mismatch ?

    Thanks,
    Shiva.

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Could you post which options are you putting in the imp command?

    Regards

    Angel

  3. #3
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    This is my Parameter file

    FILE = aleron_udb.dmp
    TOUSER = aleron_data
    FROMUSER = sys


  4. #4
    Join Date
    Sep 2000
    Posts
    384
    Warning: the objects were exported by SYS, not by you

    This will occur when you start importing from a user other the exported userid ..So nothing wrong in this error message ...

    use the show or indexfile to see the contents of the dump ...

    Radhakrishnan.M

  5. #5
    Join Date
    Sep 2000
    Posts
    384
    sys objects cannot be imported boss ...
    Radhakrishnan.M

  6. #6
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Actually the SYS object was used so that all the objects of all the required schemas could be exported.
    Now how do I go about importing it ?
    If SYS objects could not be imported, is there any other alternative way to export all the schemas ( May be FULL = Y) ?

    Thanks,
    Shiva.

  7. #7
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Hi,

    Is the best moment to organize your database. You shall import one scheme every time:

    1. Create tablespace scheme A.
    2. Create user with default tablespace A.
    3. imp sys/passwd file=XXX log=XXX indexfile=file fromuser=A touser=A
    With this you have the code for the index creation.
    4. imp sys/passwd file=XXX log=XXX indexes=no grants=y fromuser=A touser=A buffer=XXXX
    5. Execute the creation indexes script.

    Hope that helps

    Angel

  8. #8
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Ops,

    You will need at least one index tablespace for each scheme if you want a separate scheme (data and indexes).

    Regards

    Angel

  9. #9
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    So does this mean that even if the import is done with username = 'SYS', I should be able to do an import schema wise ?? Or does the export also need to be schema wise ?

    Thanks,
    Shiva.

  10. #10
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    And also, I was trying to see the contents of the export file using the SHOW parameter as

    FILE = aleron_udb.dmp
    TOUSER = aleron_data
    FROMUSER = sys
    SHOW = Y

    but it doesn't seem to work. Is there any other environment variable which needs to be set ?

    Thanks.


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