OraFAQ Forum: Server Administration » Space allocation problem! Please help!

Home » RDBMS Server » Server Administration » Space allocation problem! Please help!

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

Space allocation problem! Please help! [message #60448]

Sun, 08 February 2004 23:55

Patrick Tahiri
Messages: 119
Registered: January 2004

Senior Member

Hi,

I have a space allocation problem:

I have a locally managed tablespace with 23600 MB in total and 21200 MB are used so I still have 2400 MB free:

CREATE TABLESPACE "USERS"
�� LOGGING
�� DATAFILE '/data/u03/oradata/stat/data01.dbf' SIZE 22600M
�� REUSE AUTOEXTEND
�� ON NEXT� 16K MAXSIZE� 65535M, '/export/u05/oradata/stat/
�� data02.dbf' SIZE 1000M REUSE EXTENT MANAGEMENT LOCAL UNIFORM
�� SIZE 102400K

I have extracted some DDL of another schema and I try to implement this DDL as a new user (new schema) on this tablespace. I have about 45 tables to implement and I set for each table a very small storage clause (initial 80K and next 1M):

tablespace USERS
� pctfree 10
� pctused 40
� initrans 1
� maxtrans 255
� storage
� (
�� initial 80K
�� next 1M
�� minextents 1
�� maxextents unlimited
�� pctincrease 0
� );

The problem is that after a implementing a couple of tables, all the space - 2400 MB - remaining is consumed!! Howcome? I'm just implementing empty tables (DDL) with a so small storage setting? Could someone explain me?

Thank you in advance!

Regards,

Patrick Tahiri.

Report message to a moderator

Re: Space allocation problem! Please help! [message #60451 is a reply to message #60448]

Mon, 09 February 2004 03:42

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

is this a 9i database?

make sure u have the segment space management in TABLESPCACE is manual and NOT AUTO.

when database is created with DBCA, dbca auotmatically allocates certain defualt tablespaces with automatica segment space management.

create tablespace xxxx
datafile 'xxxxxxxxxxxxxxxxxxxxxxxxx' size nnM
extent management local segment space management Manual

Report message to a moderator

Re: Space allocation problem! Please help! [message #60456 is a reply to message #60451]

Mon, 09 February 2004 04:18

Patrick Tahiri
Messages: 119
Registered: January 2004

Senior Member

Hi, yes I'm using Oracle 9i. Is it by default MANUAL: if so then I'm using maual...

Regards,

Patrick Tahiri.

Report message to a moderator

Previous Topic:	DBMS_METADATA.GET_DDL - How to install? Special privileges? Extract all user schema?
Next Topic:	Granular Size

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 21:48:08 CST 2025