export / import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: export / import

  1. #1
    Join Date
    Jul 2005
    Posts
    87

    export / import

    suppose i have 15gb of users(total space allocated) tablespace so i need to have 15gb on target db or is it the used space that should be same on both prd and dev db's ,Do i need to have same sizes of tablespaces on both source
    and target in terms of space allocated ? i already created db,tablespaces thru script on dev box my question is some of the sizes are different (tablespaces) from prod to dev so i need to add datafile to increase the size.

    Thanks

  2. #2
    Join Date
    Jun 2002
    Location
    Longmont, Colorado
    Posts
    174
    All you need is to have the tablespace - same name. Specific size doesn't matter... you just need to allocate enough to accomodate the current used space that's on the source db.

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