Oracle 9i how to create dictionary managed tablespace

5 pts.
Tags:
Database
DBCA
Oracle 9i
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jcmdba
    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
    555 pointsBadges:
    report
  • Pinki
    [...] Reference: Oracle 9i How to Create Dictionary Managed Tablespace [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following