1.How can you get the size of the tablespace.

> Check dba_free_space
==============================================
A simple query to get information about the free space in a tablespace is:

SELECT TABLESPACE_NAME,BLOCK_ID,BLOCKS,BYTES FROM DBA_FREE_SPACE

Depending on the problem, the solution to apply can vary from adding new
datafile to recreating the tablespace in order to defragment it. To know
which is the problem, the DBA should look up on DBA_FREE_SPACE and check
how freed is the tablespace.

If the tablespace have no space avaliable, the solution can be:
1. Add a new datafile, to do this activity use the ALTER TABLESPACE command.
for futher more information about the command see Oracle Server SQL
Reference manual.

2. Resize the current datafile, please check the [NOTE:1029252.6] to know
how to Resize a Datafile and see the Oracle Server SQL Reference manual
to check the ALTER DATABASE command.

If the tablespace is fragmented the only solution is to reorganize the
tablespace.

================================================================


2. What are the changes you need to make in the etc/system file before
creating the database on it.


This depend on what version U are

> Those specified below are for Oralce 8.1.7

===========================================

HTHU

Ankur Shah
Oracle DBA
DHR-GA


----- Original Message -----
From: Deepak Gupta
To: LazyDBA.com Discussion
Sent: Thursday, October 31, 2002 4:25 PM
Subject: SIze of the tablespace


Hey Guys,
1.How can you get the size of the tablespace.

2. What are the changes you need to make in the etc/system file before
creating the database on it.

Thanks






Do you Yahoo!?
HotJobs - Search new jobs daily now
Oracle LazyDBA home page