| sudheer pai |
Posted: Sep 19, 2007 03:23:40 AM |
Total Post: 34
Joined: Feb, 2007
|
hi
i have a question pls try to answere it..
when i create non system tablespace and give extent management as dictionary
information abt the free extent is stored in data dictionary table..
now if i create my system tablespace in locally managed..
then why can't we create a non system tablespace with extent management dictionary...???
|
|
|
 Mohammed Taj |
| Posted: Sep 19, 2007 04:15:30 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
Hi,
Oracle Version: ???
In 10g. system tablespace is locally managed.
Regards
Taj
|
|
|
|
|
| dbavinod |
| Posted: Sep 19, 2007 04:26:00 AM | |
|
Total Post: 90
Joined: Sep, 2006
|
Hello,
In a database with a locally managed SYSTEM tablespace, dictionary tablespaces cannot be created. It is possible to plug in a dictionary managed tablespace using the transportable feature, but it cannot be made writable.
it is not supported, uet$ and fet$ are not to be used in a database with only LMTs and to have a dictionary managed tablespace, uet$ and fet$ are mandatory.
Vinod
|
|
|
|
|
| sudheer pai |
| Posted: Sep 19, 2007 08:14:11 AM | |
|
Total Post: 34
Joined: Feb, 2007
|
i have not worked on 10g...
can i create a dic managed tablespace
|
|
|
|
|
| parthokonar |
| Posted: Sep 21, 2007 10:40:54 AM | |
|
Total Post: 27
Joined: Sep, 2007
|
As System Tablespace is locally managed and data dictionary tables are present in System, which holds information about other non system tablespaces also So when we do some query, information are gathered from data dictionary views, which it itself is locally managed, this is the reason behind it.
And Locally Managed Tablespace Provides efficient storage management functionality that improves reliability and reduces fragmentation, so from 9i the system tablespace is locally managed.
|
|
|
|
|
| positive |
| Posted: Jun 29, 2008 03:08:03 PM | |
|
Total Post: 483
Joined: Jun, 2008
|
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
