| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Locally managed tablespaces...SOLVED!!
The tablespace cannot be changed from Data Dictionary to Locally Managed
after it's been created (according to some documentation I found). The
tablespace must be created that way from the begining:
CREATE TABLESPACE JUNK
DATAFILE '/BLAH/BLAH/BLAH.DBF' SIZE 100M EXTENT MANAGEMENT LOCAL
ONLINE PERMANENT;
It also appears that the rollback tablespace MAY NOT be locally managed.
After creating it as such it would not let me create rollbacks in the
tablespace until I recreated it as data dictionary managed.
Thanks to all who replied,
-Rocky
 |
 |