摘要: SQL> select * from nls_database_parameters where parameter='NLS_CHARACTERSET';SQL> shutdown immediateSQL> startup mountSQL> alter system enable restricted session;SQL> show parameter job_queue_processes;SQL> alter system set job_queue_processes=0;SQL> alter database open 阅读全文
posted @ 2012-12-04 12:13 秋裤大叔 阅读(202) 评论(0) 推荐(0) 编辑
摘要: [user@user ~]$ sqlplus /nologSQL> conn sys/pwd123 as sysdbaSQL> startup[user@user ~]$lsnrctl start创建临时表空间create temporary tablespace user01_temptempfile '/opt/oracle/oradata/user01/user01_temp.dbf'size 128m;创建数据表空间create tablespace user01loggingdatafile '/opt/oracle/oradata/user01/ 阅读全文
posted @ 2012-12-04 11:20 秋裤大叔 阅读(313) 评论(0) 推荐(0) 编辑