Re: locally managed tablespace

I would believe the SQL Reference manual; IMO it should be more accurate as it is in fact a 'reference' manual. The Administrator's Guide is exactly that, a guide. (Not implying that errors can not enter a reference manual, but it seem less likely.)

/Hans

"m.mueller" wrote:

> >>"m.mueller" wrote:
 

> >> Currently I'm studying space managment in tablespaces.
> >> I'm not quite sure if I understand the concept ( my questiom may sound
> >> very basic).
> >> Locally managed tablespaces offers o lot of advantages, compared to the
> >> default dictionary managed method.
> >> Furthermore since Oracle 8.1 I'm able to create a Database with a
> >> locally managed SYSTEM tablespace, not only some tablesspaces (eg DATA),
> >> if I correctly understand the Administrator's Guide.
> >> Are there any reasons (advantages) in dictionary managed tablespaces if
> >> I don't have to worry about backward compatabilities? (revert to a
> >> Oracle version prior 8.1)
> >> Any suggestions are welcome.
> >> Thank's a lot and have a nice day
> >>
> >> Manuela Mueller
 

> >You can not crate a locally managed SYSTEM tablespace. Granted the docs on
> >technet say that ... but it is not possible.
 

> >Threre are no known advantages to dictionary managed tablespaces except the
> >single case, above, where one is still mandatory.
 

> >Backward compatibility is not an issue.
 

> >Daniel A. Morgan
>
> Thank's a lot, I've tried it with 'uniform size' and 'autoallocate' and
> got error messages.
> a) with autoallocate
> CREATE DATABASE local01
> LOGFILE
> GROUP 1 ('/mnt/ora8_1_7/oradata/local01/log1a.rdo',
> '/mnt/ora8_1_7/oradata/local01/log1b.rdo') SIZE 50 K,
> GROUP 2 ('/mnt/ora8_1_7/oradata/local01/log2a.rdo',
> '/mnt/ora8_1_7/oradata/local01/log2b.rdo') SIZE 50 K
> MAXLOGFILES 5
> MAXLOGMEMBERS 2
> DATAFILE '/mnt/ora8_1_7/oradata/local01/system01.dbf' SIZE 30 M
> EXTENT MANAGMENT LOCAL AUTOALLOCATE
> MAXDATAFILES 15
> CHARACTER SET US7ASCII;
> error message:
> EXTENT MANAGMENT LOCAL AUTOALLOCATE
> *
> ERROR at line 8:
> ORA-02165: invalid option for CREATE DATABASE
>
> b) with 'uniform size'
> ... DATAFILE '/mnt/ora8_1_7/oradata/local01/system01.dbf' SIZE 30
> M...
> error message:
> EXTENT MANAGMENT LOCAL AUTOALLOCATE
> *
> ERROR at line 8:
> ORA-02165: invalid option for CREATE DATABASE
>
> In Administrator's Guide the possibility of a locally managed SYSTEM
> tablespace is mentioned and I'm directed to SQL Reference.
> The SQL Reference didn't describe this possibility.
> I naively believed the Administrator's Guide, it sounds too good...
>
> Manuela Mueller
  Received on Sun Jun 24 2001 - 21:07:49 CDT