Help!: Export/Import question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Help!: Export/Import question

  1. #1
    Join Date
    Sep 2001
    Location
    Mexico
    Posts
    93

    Question Help!: Export/Import question

    Hi friends I have a question.

    First , I'm going to tell you my problem:

    I have squemas in some databases and I want to consolidate the information importing each one to a new schema in a central database.

    In this point I have still a problem because each user that I'm importing makes references, grants, etc to the old user names.

    Do you know how can I fix the export in order each imported user either grants or references to another user name ?
    For instance, I have these schemas in each regional databases:
    catalog,
    user,
    cat_user,
    ...
    etc

    Each schema has relations, references, grants, etc to another schemas.

    So, I make a full export of each regional database and after that I create the structure in my central database for each user:
    catalog1,
    user1,
    cat_user1,
    catalog2,
    user2,
    cat_user2,
    catalog3,
    user3,
    cat_user3,


    Then, I make imports for each regional database:
    imp system/manager file=dump_region1.dmp fromuser=catalog
    touser=catalog1 full=n ignore=y

    But I still having a problem because the file dump_regionN.dmp still making references to old schemas user and cat_user.

    Do anybody know how to fix the export in order to reference the new users (user1 and cat_user1)?
    That means catalog1 will grant to user1 and cat_user1 instead the old schemas names (user and cat_user).

    Thank you for all your answers
    Regards

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,443
    Have you tried using the GRANTS=N and CONSTRAINTS=N options?

    Also you can do:

    imp system/manager file=dump_region1.dmp show=y

    to extract the SQL statements.


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