| creating undo tablespace [message #161488] |
Sun, 05 March 2006 07:51  |
vijaychauhan
Messages: 106
Registered: December 2005
|
Senior Member |
|
|
|
I have an oracle 9i release 2 database on Windows 2000, I have the database in no archivelog mode, intially there was only system tablespace, if I add another permanent tablespace and do not add a undo tablespace will the data be added to the permanent tablespace.
|
|
|
|
| Re: creating undo tablespace [message #161532 is a reply to message #161488] |
Sun, 05 March 2006 23:35  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Can you elaborate your problem more?
Do you mean to say that you have a database without undo tablespace??
Can you post the output of following query from your database?
select file_name,tablespace_name from dba_data_files; |
|
|
|
| Re: creating undo tablespace [message #161677 is a reply to message #161532] |
Mon, 06 March 2006 11:13 |
vijaychauhan
Messages: 106
Registered: December 2005
|
Senior Member |
|
|
I had a system tablespace when I, created the database, Then I added a permanent tablespace, then I added a undo tablespace. now the database does not allow me to create any object in the permanent tablespace. The output will be
D:\oracle\oradata\om\system01.dbf system
d:\oracle\oradata\om\gr01.dbf gr
d:\oracle\oradata\om\undotb01.dbf undotbs
|
|
|
|
|
|
| Re: creating undo tablespace [message #162084 is a reply to message #161488] |
Wed, 08 March 2006 11:12 |
vijaychauhan
Messages: 106
Registered: December 2005
|
Senior Member |
|
|
create table emp (empno number(2)) tablespace gr;
create table emp (empno number(2)) tablespace gr
*
ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace 'GR'
SQL> create table emp (empno number(2));
Table created.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
