Oracle Database Discussions

Hi,



I have a table TBL_VIEW_OTB.



CREATE TABLE CENTRAL.TBL_VIEW_OTB

(

CARDNO VARCHAR2(16 BYTE) NOT NULL,

CRLIMIT NUMBER,

OUT_BAL NUMBER,

PEND_AMT NUMBER,

AVAIL_LMT NUMBER,

CASH_AVAIL FLOAT(126)

)



When I am trying to drop the table



I got this error message

Error: ORA-12083: must use DROP MATERIALIZED VIEW to drop "CENTRAL"."TBL_VIEW_OTB"



When I am trying to drop the materialized view, it is showing materialized view dropped.

But TBL_VIEW_OTB still exists and the error repeats when trying to drop the table.

Error: ORA-12083: must use DROP MATERIALIZED VIEW to drop "CENTRAL"."TBL_VIEW_OTB"



SQL> SELECT * FROM DBA_OBJECTS

WHERE OBJECT_NAME=’TBL_VIEW_OTB’



OWNER
OBJECT_NAME
SUBOBJECT_NAME
OBJECT_ID
DATA_OBJECT_ID
OBJECT_TYPE
CREATED
LAST_DDL_TIME
TIMESTAMP
STATUS
TEMPORARY
GENERATED
SECONDARY

CENTRAL
TBL_VIEW_OTB

1,098,853

MATERIALIZED VIEW
03/28/2011 14:02:14
03/28/2011 14:02:14
2011-03-28:14:02:14
INVALID
N
N
N

CENTRAL
TBL_VIEW_OTB

1,098,852
1,098,852
TABLE
03/28/2011 14:00:31
03/28/2011 14:02:13
2011-03-28:14:00:31
VALID
N
N
N




SQL> SELECT * FROM DBA_SEGMENTS

WHERE SEGMENT_NAME=’TBL_VIEW_OTB’



OWNER
SEGMENT_NAME
PARTITION_NAME
SEGMENT_TYPE
TABLESPACE_NAME
HEADER_FILE
HEADER_BLOCK
BYTES
BLOCKS
EXTENTS
INITIAL_EXTENT
NEXT_EXTENT
MIN_EXTENTS
MAX_EXTENTS
PCT_INCREASE
FREELISTS
FREELIST_GROUPS
RELATIVE_FNO
BUFFER_POOL

CENTRAL
TBL_VIEW_OTB

TABLE
CENTRALNEW
28
258,857
10,485,760
1,280
25
65,536

1
2,147,483,645

1
1
28
DEFAULT