Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Exporting a database

root> su - oracle

root> export ORACLE_SID = ssss

root> sqlplus / as sysdba

note : if the memory is not sufficient we need to execute the following command as a root user at OS level

                root> !mo

                       mount -t tmpfs shmfs -o size=2g /dev/shm

SQL> select name,open_mode from V$database;

SQL> select name from V$tablespace;

SQL> select name from V$datafile.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Flag Counter