Home » RDBMS Server » Server Administration » free space
free space [message #60160] Tue, 20 January 2004 03:48 Go to next message
bath
Messages: 1
Registered: January 2004
Junior Member
how can i get the free space in a tablespace?

thanks

Report message to a moderator

Re: free space [message #60161 is a reply to message #60160] Tue, 20 January 2004 04:00 Go to previous messageGo to next message
croca
Messages: 50
Registered: January 2004
Member
You can resize the datafile, you can COALESCE to pack free contiguous space into ONE big space...
example:
alter database datafile '/u01/oradata/datafile.dbf' resize 300M;

you must first select from dba_data_files to get the file name and size.
Regards

C.J.R.
www.otools.com.ar

Report message to a moderator

Re: free space [message #60170 is a reply to message #60161] Tue, 20 January 2004 11:46 Go to previous message
Knm Dibba
Messages: 3
Registered: January 2004
Junior Member
to check for space left in a tablespace, query dba_free_space.

Report message to a moderator

Previous Topic: what is Sample Clause in Select Statement
Next Topic: Problem in connecting while Creating a Database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:23:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.