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

Thread: Storing table's data in a particular datafile

  1. #1
    Join Date
    Sep 2005
    Posts
    5

    Storing table's data in a particular datafile

    Hello

    Is there anyway that i can tell oracle that to put the data of a particular table in a tablespace to a specific datafile. so that i can store data of different tables in a tablespace saperately in differet specific datafiles.

    thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    nope, sorry.

    What are you trying to achieve?

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Use different tablespaces with single data files
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    yes it is possible to store data in a particular datafile of a tablespace by allocating extent for that table in a particular datafile.

    ALTER TABLE dept
    ALLOCATE EXTENT ( SIZE 20K DATAFILE 'dept_file7' INSTANCE 7);
    ~KD.DBA~

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    and how do you now which extent your data is going in? You cant tell which datafile the first extent gets created on. What if it allocated itself a new extent in a different datafile?

  6. #6
    Join Date
    Oct 2005
    Location
    Indianapolis
    Posts
    100
    As davey said, the question is "What are you trying to achieve?"

    Are you splitting them out for performance reasons?
    "False data can act only as a distraction. Therefore. I shall refuse to perceive you." - Bomb #20

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