Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with version 6, can anybody help ?
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