Help

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • kwartz
    New Member
    • Dec 2007
    • 35
    #1

    Help

    Code:
    CREATE TABLESPACE mytbs1
DATAFILE ‘/u01/oracle/data/mytbs01.dbf’ SIZE 500M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
    Can somebody please explain to me what this part of the code means:

    DATAFILE ‘/u01/oracle/data/mytbs01.dbf’ SIZE 500M
    Tags: None
    • amitpatel66
      Recognized Expert Top Contributor
      • Mar 2007
      • 2358
      #2
      Originally posted by kwartz
      Code:
      CREATE TABLESPACE mytbs1
DATAFILE ‘/u01/oracle/data/mytbs01.dbf’ SIZE 500M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
      Can somebody please explain to me what this part of the code means:

      DATAFILE ‘/u01/oracle/data/mytbs01.dbf’ SIZE 500M
      The DATAFILE to which the tablespace should refer to or make use of is the path that is given followed by DATAFILE keyword. The data that you store in this tablespace mytbs1 will internally store the data in to the DATAFILE that you mentioned.

        Comment

        Previous template Next
        Working...