Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003

    Unanswered: Table space and Data files

    dear friends,

    i have two database users say, user1 and user2.

    which of the following option is better.

    1.user1 and user2 having the same table space with single
    large datafile(sys1.ora).

    2.user1 and user2 having different table spaces with multiple

    could you plz tell me the right combination of values for
    creating table space(like initial size,next size,min size)
    for a large database that can grow upto 2GB/year.

    thank you.

  2. #2
    Join Date
    Nov 2002
    it is always a good idea not to take system tablespace for additional schemas in the database instance

    I always prefer giving schemas/owners their own tablespace except for some playground to developers who share one tablesspace

    a tablespace can consist of many datafiles
    one datafile can only be attached to one tablespace

Posting Permissions

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