-
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
Ravi Prasad
-
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.
Jeff Hunter
-
Where can I get dbassist?
Thanks!
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|