Re: Just getting started

"M Greener" <mmgreener_at_sprintmail.com> wrote in message news:aNA95.45774$_b3.1273719_at_newsread1.prod.itd.earthlink.net...
> I am just getting started with Oracle and I am having a few conceptual
> problems. I just want my own table space to test my application, but I
 just
> can't figure out exactly what to do. I want to be a separate user that
 has
> full access to every table that I create.
>
> Thanks,
>
> Mat Greener
>
>

Actually you are referring to two different things. Creating a schema (which is an user with tables) is on the logical side, while having the tables in their own tablespace is on the physical side. There is no obligation to put them in their own tablespace, though it is recommended.
If, however, you created a starter database, I wouldn't hesitate to use the user_data or users tablespace, because it is empty anyway. You will, btw, automatically have complete access to the tables you create. Assuming you want to create both an user and a tablespace , you need to connect as system or as sys and issue create tablespace <your tablespace>
datafile <your filename>
/
create user <youruser> identified by <yourpassword> default tablespace <your tablespace>
temporary tablespace temp
/
grant connect, resource to <youruser>

You are advised to read the Oracle concepts manual, and to use the SQL reference manual extensively. Actually this are typically FLA questions

Regards,

Sybrand Bakker, Oracle DBA Received on Sat Jul 08 2000 - 00:00:00 CDT