Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> tablespaces
Hello,
I have created a new tablespace, like this:
create tablespace tempops
datafile '/oracle/oradata/ITXC/tempops01.dbf'
size 150M
autoextend on next 50M
maxsize 450M;
I created it as 'my_user' after initiating a 'grant create tablespace to my_user'
However, when doing a 'select * from user_tablespaces' I am not able to see the newly created tablespace ? What have I forgotten ?
Thanks.
/mich
-- Regards, Michael L. Hostbaek -= So long, and thanks for all the fish.. =-Received on Fri May 09 2003 - 04:09:52 CDT