Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Location
    South Africa
    Posts
    41

    Question Unanswered: Table Space Size?

    Hi PPL

    I have a question about creating tablespaces and using an accurate size.

    I am going to create a Test DB but import from a LIVE DB but I am not too sure about tablespace size.

    There are only 2 new tablespaces that need to be created. So when I go to DBA Studio and get the Live DBs tablespace size, the one is 2.2 gigs and the other is 700mb.

    In my script, what size should I specify, I am thinking of adding a extra 100 mb just to make sure that the size is big enough, there problem is that before we used a tablespace size that was too big and the DB was too small and I dont want to use a tablespace thats too small cause it will bomb out on the import....

    Any recommendation???

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Provided you have the diskspace create the tablespace with 700M but put autoextend on (see create tablespace syntax on technet) so the tablespace will grow if necessary. If necessary you can specify a max size it will grow to.

    Alan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •