TWO DATAFILES AT A TIME
ccreatet tablespace test datafile 'C:\oraclexe\oradata\xe\test1.dbf' size 1m ,'C:\oraclex\oradata\xe\test2.dbf' size 1m ;
Statement processed.
0.72 seconds
SELECT TABLESPACE_NAME, FILE_NAME, FILE_ID
FROM DBA_DATA_FILES
WHERE TABLESPACE_NAME = 'TEST';
TABLESPACE_NAME FILE_NAME FILE_ID
TEST C:\ORACLEXE\ORADATA\XE\TEST1.DBF 8
TEST C:\ORACLEXE\ORADATA\XE\TEST2.DBF 9
Statement processed.
0.72 seconds
SELECT TABLESPACE_NAME, FILE_NAME, FILE_ID
FROM DBA_DATA_FILES
WHERE TABLESPACE_NAME = 'TEST';
TABLESPACE_NAME FILE_NAME FILE_ID
TEST C:\ORACLEXE\ORADATA\XE\TEST1.DBF 8
TEST C:\ORACLEXE\ORADATA\XE\TEST2.DBF 9
Comments
Post a Comment