Home » SQL & PL/SQL » SQL & PL/SQL » Tablespace and tables
Tablespace and tables [message #221892] Wed, 28 February 2007 19:04 Go to next message
Messages: 82
Registered: April 2006
Tablespace definition I found on Google:
a tablespace is a logical group of data files in a database

Does that mean one tablespace includes several files thathold several tables (with fields and values)? As an Oracle user I dont really have to know or maintain tablespaces and I assume just the DBA should touch or change tablespace info?

Is this accurate:

Tablespace called mySpace has 4 tables in it and mySpace consists of several files that are located on the operating system hosting the database??
Re: Tablespace and tables [message #221894 is a reply to message #221892] Wed, 28 February 2007 20:16 Go to previous message
Messages: 24963
Registered: January 2009
Location: SoCal
Senior Member
A tablespace consists of one or more datafiles.
Previous Topic: SQL error checking, need help.
Next Topic: Problems with PIVOT type query
Goto Forum:

Current Time: Mon Oct 24 17:29:40 CDT 2016

Total time taken to generate the page: 0.07682 seconds