Export / Import question (User definitions)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Export / Import question (User definitions)

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818

    Export / Import question (User definitions)

    Building new version of an application and its DB.
    Old version is 8.1.5.0, new version will be 9.2.0.4.0

    I'll create a target DB in the 9R2 system. New scripts will be run to create new versions of existing (8i) tables - the new tables have additional columns etc.

    I want to export one schema only (so USER=username is in the parameter file). A user specific export does not export User definitions, according to the docs.

    When I import into my target database will I have to manually recreate all the Oracle user accounts of the users, and grant all the privileges to them all over again?

    I don't want to use a FULL=Yes parameter as I'm creating new tablespaces for the tables in my 9R2 scripts (and the table structures differ too of course).

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    object level privs come over in a user level export. pre-create your users and give them appropriate system privs. Maybe now would be a good time to create a "SCHEMA_OWNER" role that had appropriate system privs...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    What about...

    IGNORE=Y
    I remember when this place was cool.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by Mr.Hanky
    What about...

    IGNORE=Y
    and how does that help?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    I use
    SQL>exp system/*****@bee123 file=my_8i_dump owner=(my_user,other_users)

    SQL>imp system/*****@qwerty123 file=my_8i_dump.dmp fromuser=my_user touser=my_user
    Able was I ere I saw Elba

  6. #6
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    Ooops

    file=my_8i_dump owner=(my_user,other_users)
    left out .dmp
    file=my_8i_dump.dmp owner=(my_user,other_users)
    Able was I ere I saw Elba

  7. #7
    Join Date
    Jan 2001
    Posts
    3,131

    Re: Export / Import question (User definitions)

    Originally posted by JMac

    I don't want to use a FULL=Yes parameter as I'm creating new tablespaces for the tables in my 9R2 scripts (and the table structures differ too of course).
    So couldn't you use IGNORE =Y, this way the existing structures (tablespaces included) will be ignored upon import.
    I remember when this place was cool.

  8. #8
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    ... is a very good point/suggestion.

    If it ignores the fact the tables already exist and just imports the data then that'd be fine. (I'm not that proficient with Imp/Exp )

    Let me give it a go later this week.

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