What is the correct syntax to add another datafile to the tablespace in a NuGenesis SDMS database using SQL? - WKB301861
Article number: 301861
ENVIRONMENT
- NuGenesis SDMS, all versions
ANSWER
The correct syntax is as follows:
ALTER TABLESPACE <Tablespace Name> ADD DATAFILE ',<ORADATA folder location>\<Datafile Name.DBF>' SIZE 5M AUTOEXTEND ON NEXT 50M MAXSIZE 30G;
For example:
ALTER TABLESPACE SDMS80DATA_P101 ADD DATAFILE 'E:\oracle\product\11.2.0\SDMSSR2\ORADATA\SDMS8SR2\SDMS80DATA_P101_04.DBF' SIZE 5M AUTOEXTEND ON NEXT 50M MAXSIZE 30G;
ADDITIONAL INFORMATION