OraFAQ Forum: Server Administration » Storing table's date in a particular datafile

Home » RDBMS Server » Server Administration » Storing table's date in a particular datafile

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Storing table's date in a particular datafile [message #142708]

Mon, 17 October 2005 06:26

jazzmy
Messages: 4
Registered: September 2005

Junior Member

Hay Everybody

Actually i only want to do that

I have a table space comprising of two datafiles for instance dept.ora and emp.ora and i want that all the date of emp table will be stored in emp.ora (datafile) and the data of dept table will be stored in dept.ora (datafile)

Is it possible using
ALTER TABLE emp ALLOCATE EXTENT ( DATAFILE 'emp.ora' );

thanks

Report message to a moderator

Re: Storing table's date in a particular datafile [message #142711 is a reply to message #142708]

Mon, 17 October 2005 06:45

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

I will agree and say it is possible but you have to be careful about extent allocation because all the extents should be allocated in advance.

Want others to throw their comments.

[ EDIT : But what about the extents that are allocated during table creation ( probably its 1) ]

[Updated on: Mon, 17 October 2005 06:53]

Report message to a moderator

Re: Storing table's date in a particular datafile [message #142716 is a reply to message #142708]

Mon, 17 October 2005 06:57

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Quote:

i want that all the date of emp table will be stored in emp.ora (datafile) and the data of dept table will be stored in dept.ora

Why are you looking into this?

Report message to a moderator

Re: Storing table's date in a particular datafile [message #142869 is a reply to message #142716]

Tue, 18 October 2005 02:00

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

If you are looking specifically for this thing, why not try using external tables...

--Girish

Report message to a moderator

Re: Storing table's date in a particular datafile [message #142964 is a reply to message #142708]

Tue, 18 October 2005 08:45

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

If you want to use separate datafiles then use separate tablespaces.

Report message to a moderator

Previous Topic:	creating a test schema
Next Topic:	apply patchset for 8.1.7.0 upgrade to 8.1.7.4

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 04 00:38:58 CST 2025