Basic Commands of Oracle9
Importing .dmp file to database: # imp username/passwd file=<path of dmp file> full=y To Start Oracle: # sqlplus /nolog SQL> connect / as sysdba SQL> startup To Start Listner: # lsnctr LSNCTR> start To see the Database name: SQL> SELECT NAME FROM v$database; To find out datafiles used by Tablespace: SQL> SELECT NAME FROM v$datafile;…