Oracle Database Structure: Difference between revisions
Jump to navigation
Jump to search
(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...") |
No edit summary |
||
| Line 1: | Line 1: | ||
Tablespace and 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> | |||
Revision as of 03:26, 7 October 2014
Tablespace and 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
SQL> connect sys/password as sysdba Connected.
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>
=Data File
SELECT FILE#, TS#, NAME, STATUS, ENABLED, BYTES FROM V$DATAFILE;