alter tablespace yourTablespace
add datefile filespc...
eg:
ALTER TABLESPACE tab_space2
ADD DATAFILE 'diska:tabspace_file3.dat'
SIZE 50K
AUTOEXTEND ON
NEXT 10K
MAXSIZE 100K;http://gigabase.idi.ntnu.no/oradoc/server.901/a90125/statements_33.htm#2057397
add datefile filespc...
eg:
ALTER TABLESPACE tab_space2
ADD DATAFILE 'diska:tabspace_file3.dat'
SIZE 50K
AUTOEXTEND ON
NEXT 10K
MAXSIZE 100K;http://gigabase.idi.ntnu.no/oradoc/server.901/a90125/statements_33.htm#2057397
add datefile filespc...
eg:
ALTER TABLESPACE tab_space2
ADD DATAFILE 'diska:tabspace_file3.dat'
SIZE 50K
AUTOEXTEND ON
NEXT 10K
MAXSIZE 100K;http://gigabase.idi.ntnu.no/oradoc/server.901/a90125/statements_33.htm#2057397
DATAFILE '/data2/ora9i/xxxxx02.dbf' SIZE 2048000K ;