DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Hybrid View

  1. #1
    Join Date
    Mar 2002
    I have a 7.3.4 database with numerous schemas and users that I now need to import into an existing 8.1.7 database (there are no schemas/users in the 8.1.7 database with the same name as those in the 7.3.4 database).

    To do this I intend to do the following
    1. full exp of the 7.3.4 database
    2. create schema owners/users in 8.1.7 database
    3. grant privs to schema owners/users
    4. import each schema by use of
    $imp system/password file=exp_file.dmp log=file.log fromuser=user1 touser=user1

    Is there anyway to make the creation of users and granting of privs any easier/quicker as this way seems somewhat longwinded?

    Many thanks.

  2. #2
    Join Date
    Aug 2001
    use the parfile on your import

  3. #3
    Join Date
    Jun 2000
    Madrid, Spain
    if it's empty why you dont use FULL=y?

  4. #4
    Join Date
    Mar 2002
    sorry didnt make it clear - the 8.1.5 database is not empty - does hold various schemas (but the schema names do not clash with the ones in the 7.3.4 database so this won't be an issue)

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.