THANK YOU SYBRAND.
Now I'm subscribing to the oracle technet as you suggested and finding a
wealth of information there.
Sybrand Bakker <postmaster_at_sybrandb.demon.nl> wrote in article
<937077568.10326.0.pluto.d4ee154e_at_news.demon.nl>...
> Tables are stored in tablespaces, tablespaces are made of up data files
> use
> select table_name, tablespace_name
> from user_tables
> to get a list
> Warning: If you don't do anything about it, the default tablespace of an
> user is SYSTEM.
> This is the location of the datadictionary, and you should store no
tables
> there.
> Use
> select * from user_users
> to see what the default tablespace is
> and alter user <username> default tablespace user_data (or some other
> tablespace) to change it.
> Tablespaces are made up of datafiles
> use select * from dba_data_files
> (you may do this as dba user only)
> Of course this is all described in the Oracle concepts manual and the
Oracle
> Server administrators guide.
> If you don't have them, you can read them at technet.oracle.com
>
> Hth,
>
>
> --
> Sybrand Bakker, Oracle DBA
>
>
> carlanco <askmefirst_at_yahoo.com> wrote in message
> news:01befc9d$baa827c0$78fe7ad1_at_johnboy...
> >
> >
> > This may seem like a silly question. When I create a table in SQL*PLUS
> > where is
> > that table stored. In any case, where are all the objects -- tables,
> > specially stored and how can I physically manage them.
> > Thank you for your help
>
>
>
Received on Sat Sep 11 1999 - 16:23:53 CDT
