Create tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Create tablespace

  1. #1
    Join Date
    Oct 2001
    Posts
    9

    Create tablespace

    I understand the syntax in creating a tablespace but can someone explain what is the difference is in creating a tablespaces in server manager and sqlplus.

    Many thanks
    gjb

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    It is like creating a text file in Notepad and Word. However, get used to Server Manager not being around anymore (as in the release of 9i).

  3. #3
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304

    Talking

    Similarities: Both create a tablespace in your database.
    Differences: One of them (svrmgr) has been already shown the exit door in 9i.
    Agasimani
    OCP(10g/9i/8i/8)

  4. #4
    Join Date
    Jan 2003
    Location
    india(bangalore )
    Posts
    14

    Lightbulb

    The not much different. yes but the differnt is when u create a tablespace in oms. where u will have gui. and life of a dba will be easy . even u can see the sql syntax. in case if u want ot create tablespace using sqlplus . u can . the different is u have do it by your own
    abdulkhadeer

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Originally posted by abdulkhadeer
    The not much different. yes but the differnt is when u create a tablespace in oms. where u will have gui. and life of a dba will be easy . even u can see the sql syntax. in case if u want ot create tablespace using sqlplus . u can . the different is u have do it by your own

    hmm who asked about using GUI...? he asked server manager and sqlplus, both command line tools

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width