Full Import (less sys and system)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Full Import (less sys and system)

  1. #1
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    Question

    The whole times that I have to do a full import of a base any, first I create the base that had received the import full and later I begin import, and always of the error in the users that are already created (sys and system).
    Somebody knows as doing an import full without taking the users sys and system.
    (it is not worth the clause fromuser / to user)

  2. #2
    Join Date
    Jul 2002
    Posts
    132
    sys and system are part of the database and so a full export will take it too. It is possible that certain objects are created in system too. There is no option to take a full database export without these 2.

  3. #3
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Originally posted by soniaarora
    sys and system are part of the database and so a full export will take it too. It is possible that certain objects are created in system too. There is no option to take a full database export without these 2.
    Full Export/Import take objects from SYSTEM but not sys. It is for this, when you recreate a database with an export full, you must create before the database with the create database command, RUN THE SCRIPTS, and after this run the full import.

    Cheers

    Angel

  4. #4
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    Unhappy

    Hi

    Tank you for the ansers

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