DB size??

Hi!
Need help badly!!

I am new to this DBA stuff!!
Wehave a Oracle 8 Database and we need to start testing, so have been asked to create a test database.
How do I create teh DB and how do I knowhow much space I need on the server. Is there a way to identify the production Database size? How wouldI know teh amt.of diskspace?

PlueeeZZ help!!!
Grateful to you.

Hi

this query will give the size of the database

select sum(BYTES)/(1024*1024)||' mb' 'database size' from dba_data_files;

if u want to c the free space available u have to do it at OS level

bye
ravi

There is a program called dbassist that is a GUI that can help you create your database. How big the database is depends on the size of the data.

Where can I get dbassist?
Thanks!

Just like exp/imp/sql*plus to create/modify/delete a database. Usually it will be in $O_H/bin. Otherwise you can search for it in NT/ Use find command in Unix.

You need to have x-windows in unix to invoke this utility.

Usually when installing the Oracle client for administrator dbassist also installs as part of it.