Monday, November 2, 2009

Command Penting Oracle

Listener Controller : lsnrctl
Database Manager : svrmgrl
TNS : tnsping oracleservice
Export DMP : exp user/password@database file=namafile.dmp owner=user grants=Y indexes=Y
Import DMP : imp user/password@database file=namafile.dmp fromuser=user touser=user
Login ke Oracle tanpa masuk ke DB : sqlplus /nolog --> connect username/password as sysdba
Start DB : startup
Shutdown DB : shutdown
CONNECT username/password AS SYSDBA

Sementara itu dulu command yang sering saya pakai... hehe

2 comments:

  1. dohh.. apaan nie kang? :D ndak ngerti saya.. heheheh

    ReplyDelete
  2. hehehe... saya juga sok tau kang. :D

    ReplyDelete