Re: Oracle file system - newbie

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 - 14:18:31 CDT