Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Posts
    123

    Unanswered: tablespace createtion throu shell script

    Can some one give me the script to create tablespace using shell script.
    I have written the folowing script it doesnt work
    sqlplus -s system/systempasswd <<EOF
    create tablespace "ts1" NOLOGGING
    DATAFILE "/xx/xxx/xxx.dbf"
    ONLINE;


    Pls tell me what is wrong

  2. #2
    Join Date
    Nov 2003
    Posts
    3
    Try to give the Datafile a size or an option for Extent Management

  3. #3
    Join Date
    Nov 2003
    Location
    TX
    Posts
    4

    Re: tablespace createtion throu shell script

    Originally posted by jaggu
    Can some one give me the script to create tablespace using shell script.
    I have written the folowing script it doesnt work
    sqlplus -s system/systempasswd <<EOF
    create tablespace "ts1" NOLOGGING
    DATAFILE "/xx/xxx/xxx.dbf"
    ONLINE;


    Pls tell me what is wrong
    Whats the error you are getting ?.
    Do u get script error or tblspace creation error ?.
    If it is script enter EOF in the last line.
    if it is tablespace - give more details.

  4. #4
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    HI,

    Post the elobrate Error Message.
    SATHISH .

Posting Permissions

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