-
I want to add a new datafile to one of my user tablespaces. ALTER TABLESPACE xyz ADD DATAFILE requires an existing datafile. But how the heck do I create such a new empty datafile??
(I am running Oracle 8.1.5 Personal Edition on Win98.)
-
alter tablespace xyz add datafile 'W:\ORACLE\NT815\XYZ02.dbf'
size 1024M autoextend on next 1024M maxsize 20480M;
-
hi ,
to create a new datafile
Create tablespace datafile ‘f:/oracle/.dbf’ size 100M extent management local autoextend on 10M;
i think this will help u,
regards,
Ramesh