Having issue seeing all objects in the Databases/Administer/Tablespaces/Objects, select the tablespace name but don't see the indexes just created in the script below.
Ran the script below to create the table and indexes, check schema browser and see the table, and indexes in the tab but don't see them in the Databases/Administer/Tablespaces/Objects, select Users tablespace.
Only seem to be hhappening on 11gr2 database, seem to woking in 10g fine.
CREATE TABLE EMPLOYEES
(
EMPLOYEE_ID NUMBER(6),
FIRST_NAME VARCHAR2(20 BYTE),
LAST_NAME VARCHAR2(25 BYTE) CONSTRAINT EMP_LAST_NAME_NN NOT NULL,
EMAIL VARCHAR2(25 BYTE) CONSTRAINT EMP_EMAIL_NN NOT NULL,
PHONE_NUMBER VARCHAR2(20 BYTE),
HIRE_DATE DATE CONSTRAINT EMP_HIRE_DATE_NN NOT NULL,
JOB_ID VARCHAR2(10 BYTE) CONSTRAINT EMP_JOB_NN NOT NULL,
SALARY NUMBER(8,2),
COMMISSION_PCT NUMBER(2,2),
MANAGER_ID NUMBER(6),
DEPARTMENT_ID NUMBER(4)
)
TABLESPACE users
RESULT_CACHE (MODE DEFAULT)
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
NOLOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;
Verified that the issue is because the way 11g database works. Oracle 11g does not create the segments until a row is inserted in the table. This part of Toad queries against dba_segments. Once a row is inserted, Oracle will create the segments and insert rows into dba_segments, and the objects will appear in that part of Toad.
Apparently it's the way Oracle 11g db works. Just to verify, I went in and inserted a record into the table and the objects did show up.
,
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center