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: 25574
Registered: January 2009
Location: SoCal
Senior Member
A tablespace consists of one or more datafiles.
Previous Topic: Select Day of the Week
Next Topic: ORA-29279:SMTP permanent error:553 sorry , that domain isn,t in my list of allowed rcpthosts
Goto Forum:

Current Time: Mon Aug 21 05:27:08 CDT 2017

Total time taken to generate the page: 0.04947 seconds