Any shortcuts for import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Any shortcuts for import

Hybrid View

  1. #1
    Join Date
    Mar 2002
    Posts
    2
    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
    Posts
    390
    use the parfile on your import


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

  4. #4
    Join Date
    Mar 2002
    Posts
    2
    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