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

Thread: new database

  1. #1
    Join Date
    Nov 2000
    Posts
    198
    exp/imp from 8.0.5 to 8.1.6
    can I have a different db_name than the one I am importing
    from ???? and can I have different names, location, and size for my tablespaces and db_files,redo logs, control file,etc...???

    thanks,

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Sure. With import you are importing objects, not the database structure. Just create your database, create your tablespaces, create your schema owners, and import schema by schema.
    Jeff Hunter

  3. #3
    Join Date
    Nov 2000
    Posts
    198
    does that apply on full database export ????

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    If you have a full export, you can import schema by schema. If you do a full import, it will create tablespaces, and stuff for you. I recommended schema by schema because you wanted to change the physical structure of the database.
    Jeff Hunter

  5. #5
    Join Date
    Apr 2000
    Posts
    126

    Wink new database

    You can precreate the tablespaces and specify ignore=y. This will "ignore" the create tablespace statements as long as the tablespace names are the same.

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