Re: Oracle Myths

Hi there

Sometimes cannot post to this newsgroup.

Oracle [8,8i,] 9i SQL Reference/CREATE DATABASE. Datafiles can be specified for system tablespace and one can define extent EXTENT MANAGEMENT.

-- 
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.

"Howard J. Rogers" wrote:


> 

> As I said elsewhere:  I'll buy this, if someone will explain to me how I can

> make SYSTEM dictionary managed.

> 

> I feel a sense of deja vu over this subject, as -with the management types

> switched round, of course- I had exactly this sort of thread with a certain

> poster to these parts who insisted that he'd created a locally managed

> SYSTEM tablespace in 8.1.6.

> 

> So, the same question: how? since dictionary/local management is anattribute

> of the tablespace, not the datafile. And 'create database' doesn't have a

> 'create tablespace system' command in it.

> 

> Not saying it can't be done, and maybe there's a piece of doco I need to

> read. But...

> 

> Regards

> HJR