Oracle Database Structure - Revision history

Nicolas Rollin at 02:44, 12 October 2014

2014-10-12T02:44:24Z

← Older revision		Revision as of 02:44, 12 October 2014
Line 25:		Line 25:
	SQL></pre>		SQL></pre>

	===Data File ==		==Data File ==
	<pre>		<pre>
	SELECT FILE#, TS#, NAME, STATUS, ENABLED, BYTES FROM V$DATAFILE;		SELECT FILE#, TS#, NAME, STATUS, ENABLED, BYTES FROM V$DATAFILE;
	</pre>		</pre>

Nicolas Rollin at 03:26, 7 October 2014

2014-10-07T03:26:21Z

← Older revision		Revision as of 03:26, 7 October 2014
Line 1:		Line 1:
	==Tablespace==		Tablespace and Data Files
	==Data Files==

	* The Table space is a logical space which have at least one data file which is a physical file.		* The Table space is a logical space which have at least one data file which is a physical file.
Line 25:		Line 24:

	SQL></pre>		SQL></pre>

			===Data File ==
			<pre>
			SELECT FILE#, TS#, NAME, STATUS, ENABLED, BYTES FROM V$DATAFILE;
			</pre>

Nicolas Rollin: Created page with "==Tablespace== ==Data Files== * The Table space is a logical space which have at least one data file which is a physical file. * One data file is attached to one and only one..."

2014-10-07T03:17:10Z

Created page with "==Tablespace== ==Data Files== * The Table space is a logical space which have at least one data file which is a physical file. * One data file is attached to one and only one..."

New page

==Tablespace==
==Data Files==

* The Table space is a logical space which have at least one data file which is a physical file.
* One data file is attached to one and only one table space;
* Table are in a table space;

===Table Space List ===
Connect as sysdba with sqlplus and
Select * from v$TABLESPACE

<pre>SQL> connect sys/password as sysdba
Connected.
</pre>
<pre>
SQL> select * from V$TABLESPACE;

TS# NAME INC BIG FLA ENC CON_ID
---------- ------------------------------ --- --- --- --- ----------
1 SYSAUX YES NO YES 0
0 SYSTEM YES NO YES 0
2 UNDOTBS1 YES NO YES 0
4 USERS YES NO YES 0
3 TEMP NO NO YES 0

SQL></pre>