Category Archives: oracle

Oracle 9i Note

Posted on February 13, 2009 by Jianming Li

9i •SPFILE CREATE SPFILE = ‘filename’ FROM PFILE = ‘pfilename’ CREATE SFILE = ‘pfilename’ FROM SPFILE = ‘filename’ ALTER SYSTEM set parameter = val SCOPS = MEMORY | SPFILE | BOTH •Connect internal CONNECT user/passwd AS SYSDBA sqlplus ‘/as sysdba’ … Continue reading →

Posted in oracle | Leave a comment