Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with version 6, can anybody help ?

Re: Problem with version 6, can anybody help ?

From: Peter McKenzie <pemmck_at_ibm.net>
Date: 1997/10/01
Message-ID: <60shhq$fbj$1@marri.bs.wa.gov.au>#1/1

 Try Alter tablespace add ...... - alter partition is a version 5 command I think .

John Caveney wrote in article
<01bccdc1$db444d40$dcae989e_at_flintscn.demon.co.uk>...

>We are still using version 6.0.30.3.1 of Oracle and we are trying to add
>another partition to our database.
>
>We go into sqlplus as SYSTEM/password.
>
>We type in the following -:
>
>ALTER PARTITION SYSTEM ADD FILE '/u/oratables/dbsF.dbf'
>
>and each time we get the following ;-
>
>ALTER PARTITION SYSTEM ADD FILE `/u/oratables/dbsF.dbf'
> *
>ERROR at line 1:
>ORA-00940: invalid ALTER command.
>
>Are we doing something wrong ?
>
>If you can help I would be grateful.
>
>Best regards
>
>John Caveney.
>
>
>
Received on Wed Oct 01 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US