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?
Grateful to you.
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
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?
Its GUI based oracle utility
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.
Click Here to Expand Forum to Full Width