| |
GeekInterview.com > Tech FAQs > Oracle > Database Administration
| Print | |
Question: How do you find the total database size in the database, is there any command to see the database size or in os level?
2.can we unload the data by using sql*loader?
3.can we take incremental backup with out taking complete backup?
|
| August 08, 2007 02:48:42 |
#1 |
| parthokonar1 |
Member Since: October 2006 Total Comments: 15 |
RE: How do you find the total database size in the dat...
|
for ques 1. The size of the database is the total size of the datafiles that make up the tablespaces of the database. These details are found in the dba_extents view. type the following lines at the SQL-PLUS prompt:
select sum(bytes/1048576) from dba_extents;
This will give the total number of Mb used by your database.
2. yes but more clarification is needed
3. No. First full backup is needed
|
| |
Back To Question | |
