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 -> Re: File location?

Re: File location?

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Thu, 22 Nov 2001 07:23:46 GMT
Message-ID: <6K1L7.56006$XJ4.33841836@news1.sttln1.wa.home.com>


It is created in the default tablespace of the user that you are logged in as.

So what's a tablespace?
A tablespace is a logical storage place. A tablespace consists of one or more physical data files.
Unlike dbase or clipper where a table is a physical file (which is why I am assuming you are looking for a file called sales.*) Oracle stores it's data in tablespaces which are made up of data files. Each data file can hold one or more object (e.g. a table like sales or an index on the store column in the sales table)

Do you won't find a file called sales.*. In addition, even if you found one it would not be of use to you directly. Oracle manages the storage of the data inside the files and does the reading and writing of this data for you via SQL. (Although I have always thought that there is enough documentation out there that someone could reverse engineer the read the files directly with a heck of a lot of work, but I'd rather just use Oracle to do that.)

Jim
"ROBERT WEST" <rob-west_at_worldnet.att.net> wrote in message news:qg0L7.120920$WW.7669604_at_bgtnsc05-news.ops.worldnet.att.net...
> I'm studying Oracle SQL. At the SQL> prompt, I create tables. My
question
> is this. If I create a table named "SALES" where is this file stored?
> When I look and search for SALES.* Windows 95 can not find it. But, if I
> say DESCRIBE SALES it is there.
>
> Where is it?
>
> Thank you,
> Rob-west_at_worldnet.att.net
>
>
>
>
Received on Thu Nov 22 2001 - 01:23:46 CST

Original text of this message

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