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;…