| Check number of user in tablespace [message #181843] |
Tue, 11 July 2006 21:36  |
nghiant
Messages: 38
Registered: July 2006
Location: Viet Nam
|
Member |
|
|
In tablespace has more users. How to know number of user, name of user ?
ORA-01658: unable to create INITIAL extent for segment in tablespace OPENRISTBL.
I don't know the way to increase tablespace, please help me for this problem.
Perhaps, add more datafile for tablesapce or increase quota of tablespace ?
[Updated on: Tue, 11 July 2006 21:39] Report message to a moderator |
|
|
|
| Re: Check number of user in tablespace [message #181851 is a reply to message #181843] |
Tue, 11 July 2006 23:01  |
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
|
Senior Member |
|
|
Ans1:
select USERNAME from dba_users
where DEFAULT_TABLESPACE=<Your Tablespace name>
Ans2:
Add a new datafile of 500MB size
alter tablespace <Your Tablespace name>
add datafile '<your datafile name including path>' SIZE 500M
increase size of an existing file in your tablespace .
ALTER DATABASE datafile '<your datafile name including path>' RESIZE 1000M;
Note :if inital size of of the file was 500MB,not total size of the file is 1000MB.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
