Home » Infrastructure » Unix » How do I extend the table space for a database?
How do I extend the table space for a database? [message #97997] Thu, 02 October 2003 14:24 Go to next message
jeremyf
Messages: 1
Registered: October 2003
Junior Member
I am trying to manually extend the table space for an existing database. I have 2 dumb questions:
What is the command I use to do this?
Do I have to bring the database down first?

Thanks

Report message to a moderator

Re: How do I extend the table space for a database? [message #98000 is a reply to message #97997] Thu, 02 October 2003 16:12 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
You can either add a datafile to the tablespace
eg)
alter tablespace users add datafile '/oradata/users2.dbf' size 200m;

or resize (increase) the datafile
eg)

alter database datafile '/oradata/users1.dbf' resize 200m;

Also you can AUTOEXTEND the datafile,but I generally want to be in control !

No you dont have to bring down the database.

-Thiru

Report message to a moderator

Previous Topic: Shell command question
Next Topic: String manipulation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 04:24:04 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.