Home » RDBMS Server » Server Administration » Oracle 9i in Windows XP/2000!
Oracle 9i in Windows XP/2000! [message #63461] Thu, 07 October 2004 02:13 Go to next message
dr alex
Messages: 18
Registered: June 2004
Junior Member
Hi to all,

   I have installed Oracle 9i (9.2.0.1.0)  Enterprise Edition in Windows XP and Windows 2000 Advanced Server successfully. Two Oracle Server in Windows XP and one in Windows 2000 Advanced Server (For Testing Purpose). While Creating Database, I have created 3 tablespaces, let say

1. MYDBDATA

2. MYDATA_INDX (For Index)

3. MYDATA_TEMP (temporary tablespace)

In one WinXP, I was able to create all above mentioned three tablespaces, in another one I could not create tablespace MYDATA_INDX and in Win2000, I could no create Temporary Tablespace(MYDATA_TEMP).

What's the matter? I hope somebody encountered the same problem(s)?

Pls help me!

Anup

(Nepal)

Report message to a moderator

Re: Oracle 9i in Windows XP/2000! [message #63465 is a reply to message #63461] Thu, 07 October 2004 03:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
post your create tablespace command with complete error message.

Report message to a moderator

Re: Oracle 9i in Windows XP/2000! [message #63472 is a reply to message #63465] Thu, 07 October 2004 22:31 Go to previous messageGo to next message
dr alex
Messages: 18
Registered: June 2004
Junior Member
The Script is:
--for Index
CREATE TABLESPACE MYDATA_INDX
LOGGING DATAFILE 'D:ORACLEORADATAMYDBMYDATA_INDX.ORA'
SIZE 100M REUSE DEFAULT STORAGE
(INITIAL 100M NEXT 10M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0);

ALTER DATABASE DATAFILE 'D:ORACLEORADATAMYDBMYDATA_INDX.ORA'
AUTOEXTEND ON;

--for temp tablespace
CREATE TABLESPACE MYDATA_TEMP
LOGGING DATAFILE 'D:ORACLEORADATAMYDBMYDATA_TEMP.ORA'
SIZE 100M REUSE DEFAULT STORAGE
(INITIAL 10M NEXT 10M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0)
TEMPORARY;

ALTER DATABASE DATAFILE 'D:ORACLEORADATAMYDBMYDATA_TEMP.ORA'
AUTOEXTEND ON;

The Error message was:
ORA-12913: Can not create dictionary managed tablespace.

-----
Anup

Report message to a moderator

Re: Oracle 9i in Windows XP/2000! [message #63479 is a reply to message #63472] Fri, 08 October 2004 03:32 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You system tablespace is an LMT ( locally managed tablespace).
So you cannot create a DMT ( dictionary managed tablespace).
THe syntax would be
 CREATE TEMPORARY TABLESPACE tablespace_name
      TEMPFILE Tempfile_Options 
         [EXTENT MANAGEMENT LOCAL] 
            [UNIFORM [SIZE int K | M] ];


Oracle adivces to have all your tablespaces to be LMT.

Report message to a moderator

Previous Topic: start oracle instance from command line
Next Topic: create database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 24 23:17:01 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.