dictionary managed tablespaces in 9i

[arokh]

Is it possible to create dictionary managed tablespaces in 9i and if it is how?

[jovery]

RTFM

http://otn.oracle.com/pls/db92/db92....ces.htm%239546

[arokh]

SQL> create tablespace RBS
2 DATAFILE '/u02/oradata/O8I5A/rbs01.dbf' SIZE 482344960
3 EXTENT MANAGEMENT DICTIONARY
4 DEFAULT STORAGE (
5 INITIAL 131072
6 NEXT 131072
7 MINEXTENTS 20
8 MAXEXTENTS 4096
9 PCTINCREASE 0);
create tablespace RBS
*
ERROR at line 1:
ORA-12913: Cannot create dictionary managed tablespace

what is wrong???

[stmontgo]

your system TS is locally managed

[jmodic]

If your SYSTEM tablespace is created as LMT (the default, seems to be the case in your situation too) then all other tablespaces must be LMTs too.

So if you want to create a dictionary managed tablespace (why?????) in 9i, you must have your SYSTEM tablespace created as DMT at database creation time.

[arokh]

because i am trying to import 8.1.5 database with dictionary managed tablespaces and i have problems importing.

[adewri]

Did you create the tablespaces or you trying to import the full database and want the import to create the tablespaces for you ??

In that case create the tablespaces manually before doing the import and then run the Full import. You can very well import from a database having DMT to a database having LMT.

HTH

[jmodic]

Can you be more specific? What kind of problems?

The only possible problems that I can see with this is if you are performing full import (from full export) and want the imp process to create the tablespaces too. In this case, all you have to do is to manualy create those tablespaces (asl LMT) before you start the import. That should realy be no problem.