how to find full database size
Answer / sudipta santra
select sum(bytes / (1024*1024)) "DB Size in MB" from
dba_data_files;
If u have the access of the table dba_data_files
| Is This Answer Correct ? | 3 Yes | 0 No |
How to start your 10g xe server?
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
How to export your own schema?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
Can we use bind variables in oracle stored procedure?
Can a primary key contain more than one columns?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
what is pragma?
What is program global area (pga) in oracle?
What are Schema Objects ?
what is data abstraction
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.