Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> tablespaces

tablespaces

From: Michael L. Hostbaek <carlos_at_pez.dk>
Date: 09 May 2003 09:09:52 GMT
Message-ID: <slrnbbms30.3dk.carlos@freebsdcluster.dk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US