Home » RDBMS Server » Server Administration » Tablespace Storage parameters
Tablespace Storage parameters [message #161929] Tue, 07 March 2006 23:15 Go to next message
gajini
Messages: 262
Registered: January 2006
Senior Member
During a tablespace creation,if no storage parameters are set,what would be their default values?

Ex: I've created a tbalespace as

Create tablespace tbs01
datafile 'c:\oracle\oradata\newdb\tbs01.dbf' size 500k;
Tablespace created

What would be the values for INITIAL,NEXT...& other storage parameters?

Regards,
Malru

Report message to a moderator

Re: Tablespace Storage parameters [message #161937 is a reply to message #161929] Tue, 07 March 2006 23:41 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

why don't you check ???

 DBA_TABLESPACES

Report message to a moderator

Re: Tablespace Storage parameters [message #161943 is a reply to message #161929] Tue, 07 March 2006 23:59 Go to previous messageGo to next message
gajini
Messages: 262
Registered: January 2006
Senior Member
Is there any documentation to refer the default values for those parameters?

Report message to a moderator

Re: Tablespace Storage parameters [message #161944 is a reply to message #161943] Wed, 08 March 2006 00:01 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Look into Oracle Docs.
you can download it from Oracle website (for free).

Report message to a moderator

Previous Topic: SYSTEM Tablespace
Next Topic: Role ownership?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:37:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.