Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    Swindo - UK
    Posts
    2

    Question Unanswered: Change 3 Schema Names!

    Have three schema which have grants, synonyms across the schemas need to rename the schemas.

    Thinking of export import fromuser touser, but believe this odes not sort out grants and things?

    Whats the best full proof way to do this?

  2. #2
    Join Date
    Dec 2002
    Posts
    1

    Arrow Re: Change 3 Schema Names!

    1 export grants on objects into sql-file
    2 export/import into new schema
    3 replace all references into old schema in sql file
    4 run sql-file

    item 1 perform with quering data dictionary (DBA_TAB_PRIVS, ect)

  3. #3
    Join Date
    Dec 2002
    Location
    Swindo - UK
    Posts
    2
    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
  •