一:典型安装的情况下包括Scott用户 ,默认情况下是锁定的状态,可以通过命令行来进行解锁;
-:SQL> alter user scott account unlock identefied bu tiger;
alter user scott account unlock identefied bu tiger *ERROR at line 1:ORA-00922: missing or invalid optionSQL>_:缺失或者无效的选择
然后进行查找看看有没有这个Scott
SQL> select username from dba_users where username='scott';
no rows selected
二:如果环境中没有Scott用户,那么可以利用Oracle自带的脚本来进行创建
SQL>
SQL> @?/rdbms/admin/utlsampl.sqlDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options[oracle@localhost ~]$ [oracle@localhost ~]$ [oracle@localhost ~]$ sqlplus scott/tigerSQL*Plus: Release 11.2.0.4.0 Production on Sun Sep 25 20:27:44 2016Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select * from tab;TNAME TABTYPE CLUSTERID------------------------------ ------- ----------BONUS TABLEDEPT TABLEEMP TABLESALGRADE TABLESQL>SQL> select tname from tab;
TNAME------------------------------BONUSDEPTEMPSALGRADESQL>(*?是指操作系统中环境变量$ORACLE_HOME)