Save data in oracle

[santhoshkumar samala]

My machine has oracle9i installed in C drive, as the data is getting increased the C drive is almost full now. I want the new data to be saved in some other drive say E drive. can you please tell me is it possible? then how can i do the same?

[Mark Spritzler]

That is a big topic to discuss. But basically in your configuration you point to where the datafiles are, so you have to add another "datafile" to point to the other drive.

Mark

[santhoshkumar samala]

I dont know what i mentioned while configuration, can you please help me how can I change the data storage place now?

[Mark Spritzler]

That is too huge of a topic to discuss in a forum, you will have to go to Oracle's documentation and read up on data files. Try doing a Google Search of "Oracle Data Files"

Mark

[Duke Astron]

Research on how to move or add datafiles. It's really simple if you already know SQL.

[Mark Spritzler]

Originally posted by Duke Astaroth:
Research on how to move or add datafiles. It's really simple if you already know SQL.

Hi Duke, I think this might be interpretted incorrectly. The adding a new datafile to Oracle is not about SQL, you have to go to the configuration and add and point it to the new file on the file system.

Mark

[Lukas Koniecki]

Add new datafiles to your tablespace (or/and) move existing files to "E" drive (see: http://www.psoug.org/reference/tablespaces.html)

or

add new tablespace with it's datafile placed on "E" drive and move your's tables to new tablespace (tip: alter table ... move tablespace ...)