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

Thread: export / import

  1. #1
    Join Date
    Jul 2005

    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.


  2. #2
    Join Date
    Jun 2002
    Longmont, Colorado
    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

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