OraFAQ Forum: Server Administration » No extent information for the new created table

Home » RDBMS Server » Server Administration » No extent information for the new created table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

No extent information for the new created table [message #64123]

Fri, 17 December 2004 17:20

Tomato
Messages: 1
Registered: December 2004

Junior Member

Attached is table creation SQL:
CREATE table test_log (
LOG_ID number not null,
LOG_TEXT varchar2(50))
TABLESPACE FIF_DATA03
PCTFREE 10 PCTUSED 70 INITRANS 10 MAXTRANS 255
STORAGE ( INITIAL 16K NEXT 4096K PCTINCREASE 0
MINEXTENTS 1 MAXEXTENTS 2147483645)
NOCACHE;

However, there is not extent information in all_tables.
Could anyone tell me why this situation happened and how to solve it? Thanks.

Report message to a moderator

Re: No extent information for the new created table [message #64127 is a reply to message #64123]

Sat, 18 December 2004 06:39

Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...

Senior Member

Hi,

try:

select INITIAL_EXTENT, NEXT_EXTENT,MAX_EXTENTS
from all_tables
where table_name = 'TEST_LOG';

Note, object names are stored in UPPERCASE in the data dictionary, unless you created the table with the name enclosed in double quotes.

Michael Hartley

www.openfieldsolutions.co.uk

Report message to a moderator

Re: No extent information for the new created table [message #64132 is a reply to message #64123]

Mon, 20 December 2004 07:01

shimon
Messages: 1
Registered: December 2004

Junior Member

u probably work with locally managed tablespace and automatic srorage in 9i, uniform allocation, etc ?
if u do - then its a normal picture u see: the database takes care about extent managemnt.

See in doc: ASM - Automatic Storage Management

DBA_TABLSPACES will let u know if your TS is locally managed and /or defined as AUTO-EXTEND.

Report message to a moderator

Previous Topic:	oracle 7.3.4 download site
Next Topic:	Installing ORACLE 9i (9.0.1.1.1) On Windows 2000 Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 22:36:27 CST 2025