摘要:
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 阅读全文
摘要:
[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/ 阅读全文