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

Thread: newbie question

  1. 02-01-2002, 07:10 PM #1
    tekion
    tekion is offline Junior Member
    Join Date
    Aug 2001
    Posts
    64

    Question

    Gurus,
    Can more than one tablespace be on the same datafile?

    Thanks.
    Reply With Quote Reply With Quote
  2. 02-01-2002, 08:46 PM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    no
    Reply With Quote Reply With Quote
  3. 02-02-2002, 06:44 PM #3
    star
    star is offline Junior Member
    Join Date
    Mar 2001
    Posts
    78
    But more than one datafiles can be on the same tablespace
    Reply With Quote Reply With Quote
  4. 02-03-2002, 06:26 PM #4
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    yes
    Jeff Hunter
    Reply With Quote Reply With Quote
  5. 02-03-2002, 06:27 PM #5
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    http://otn.oracle.com/docs/products/...space.htm#1945
    Jeff Hunter
    Reply With Quote Reply With Quote
  6. 02-05-2002, 02:21 PM #6
    Ablakios
    Ablakios is offline Senior Member
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374
    HI
    Think of your tablespace and your datafiles as your hand and your fingers.
    many to one relationship
    Hope this help.
    Thanks
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width