Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: alter tablespace.......

    hi,
    I need to increase my tablespace TEMPOR with oracle 8.0.5 version.

    I connected how user system:

    ALTER TABLESPACE TEMPOR
    ADD DATAFILE 'c:\oracle\oradata\.....\TEMPOR02.dbf' SIZE 100M
    AUTOEXTEND ON
    NEXT 512K
    MAXSIZE 450M;

    but I get this error:

    ORA-02142:missing or invalid ALTER TABLESPACE option

    How can I increase my tablespace with this version??

    Thanks
    Raf

  2. #2
    Join Date
    May 2003
    Posts
    87
    The syntax looks right. Has it to do with the file path 'c:\oracle\oradata\.....\TEMPOR02.dbf' ? Can you try a different path with, say 'c:\oracle\oradata\TEMPOR02.dbf' ?

  3. #3
    Join Date
    Oct 2003
    Location
    Brazil
    Posts
    1

    adding datafile to temporay tablespace

    The syntax is
    alter tablespace <tablespacename> add tempfile <datafile path> size XXXXM

Posting Permissions

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