没看过,不过应该是示例实例里的表,或者scott用户下的表.楼主在建实例的时候有个选项,是否安装示例实例,如果安装了,Oracle 的实例数据库会多一个表空间EXAMPLE的表空间,该表空间存放的就是示例的表。 SQL code SQL> conn sys/admin as sysdba SQL> alter user hr account unlock; SQL> alter user hr identified by admin; SQL> conn hr/admin; SQL> select * from user_tables;TABLE_NAME TABLESPACE_NAME ------------------------------ ------------------------------REGIONS EXAMPLE COUNTRIES LOCATIONS EXAMPLE DEPARTMENTS EXAMPLE JOBS EXAMPLE EMPLOYEES EXAMPLE JOB_HISTORY EXAMPLE
没看过,不过应该是示例实例里的表,或者scott用户下的表.楼主在建实例的时候有个选项,是否安装示例实例,如果安装了,Oracle 的实例数据库会多一个表空间EXAMPLE的表空间,该表空间存放的就是示例的表。
SQL code
SQL> conn sys/admin as sysdba
SQL> alter user hr account unlock;
SQL> alter user hr identified by admin;
SQL> conn hr/admin;
SQL> select * from user_tables;TABLE_NAME TABLESPACE_NAME
------------------------------ ------------------------------REGIONS EXAMPLE
COUNTRIES
LOCATIONS EXAMPLE
DEPARTMENTS EXAMPLE
JOBS EXAMPLE
EMPLOYEES EXAMPLE
JOB_HISTORY EXAMPLE