Oracle 9i how to create dictionary managed tablespace
Home > IT Answers > Database > Oracle 9i how to create dictionary managed ta...
Pinki
5 pts.
0
Q:
Oracle 9i how to create dictionary managed tablespace
Database, Oracle 9i, DBCA
Hi,
How can i create database with SYSTEM as dictionary-managed in Oracle 9i?. DBCA creates by default a database with locally managed system tablespace. How can i change it?

Thanks in advance.
ASKED: Jan 22 2008  2:06 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Shashi1011
20 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Hi Pinki,

Every Oracle database contains a tablespace named SYSTEM, which Oracle creates automatically when the database is created. The SYSTEM tablespace is always online when the database is open.

To take advantage of the benefits of locally managed tablespaces, you can create a locally managed SYSTEM tablespace, or you can migrate an existing dictionary managed SYSTEM tablespace to a locally managed format.

In a database with a locally managed SYSTEM tablespace, dictionary managed tablespaces cannot be created. It is possible to plug in a dictionary managed tablespace using the transportable feature, but it cannot be made writable.


Note:
Once a tablespace is locally managed, it cannot be reverted back to being dictionary managed
Last Answered: Jan 24 2008  8:50 AM GMT by Shashi1011   20 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Jcmdba   495 pts.  |   Jan 24 2008  9:49PM GMT

Pinky,
You can create a database with a dictionary managed system tablespace. A simple SQL script can be created and then executed via SQL*Plus which will create your database with all the options you might want. A simple example:
create database yourdb controlfile reuse
maxdatafiles 1064
character set “AL32UTF8″
national character set “UTF8″
datafile
‘d:\yourfilesystem\yourdb_system_01.dbf’ size 250M
extent management dictionary
undo tablespace yourdb_undo
datafile ‘d:\anotherfilesystem\yourdb_undo_01.dbf’ size 400M
logfile
group 1 (………… etc… etc.

This is a very simplistic example with limited options included. You can check the “create database” command options in any Oracle reference with the appropriate version of database you are using. The GUI tools such as DBCA don’t always provide the easiest nor complete options available for managing your Oracle databases.
jcmdba

 

Oracle 9i: How to Create Dictionary Managed Tablespace « Oracle DBA from Beginning   0 pts.  |   Jun 9 2008  7:55PM GMT

[...] Reference: Oracle 9i How to Create Dictionary Managed Tablespace [...]

 
0