延迟段创建的学习-实验(二)
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> c/hourly_empaloyees/hourly_employees;
1* select count(*) from hourly_employees
SQL> r
1* select count(*) from hourly_employees
COUNT(*)
----------
3
SQL>
SQL> select * from hourly_employees;
EMPNO NAME HOURLY_RATE
---------- ------------------------------ -----------
99 FRose 20
150 LRose 25
150 LRose 25
SQL>
SQL>
SQL> INSERT INTO part_time_employees VALUES (50, 'KReilly', 10.00);
1 row created.
SQL> INSERT INTO part_time_employees VALUES (50, 'KReilly', 10.00);
1 row created.
SQL> INSERT INTO part_time_employees VALUES (50, 'KReilly', 10.00);
1 row created.
SQL> SELECT segment_name, partition_name FROM user_segments;
SEGMENT_NAME PARTITION_NAME
------------------------------ ------------------------------
REGIONS
LOCATIONS
DEPARTMENTS
JOBS
EMPLOYEES
JOB_HISTORY
DIGITS
PART_TIME_EMPLOYEES
HOURLY_EMPLOYEES EMPNO_TO_100
HOURLY_EMPLOYEES EMPNO_TO_200
REG_ID_PK
SEGMENT_NAME PARTITION_NAME
------------------------------ ------------------------------
COUNTRY_C_ID_PK
LOC_ID_PK
LOC_CITY_IX
LOC_STATE_PROVINCE_IX
LOC_COUNTRY_IX
DEPT_ID_PK
DEPT_LOCATION_IX
JOB_ID_PK
EMP_EMAIL_UK
EMP_EMP_ID_PK
EMP_DEPARTMENT_IX
SEGMENT_NAME PARTITION_NAME
------------------------------ ------------------------------
EMP_JOB_IX
EMP_MANAGER_IX
EMP_NAME_IX
JHIST_EMP_ID_ST_DATE_PK
JHIST_JOB_IX
JHIST_EMPLOYEE_IX
JHIST_DEPARTMENT_IX
29 rows selected.
SQL>