TEMP TABLESPACE
create temporary tablespace tmp tempfile 'C:\oraclexe\oradata\xe\temp1.dbf' size 5m ;
SELECT TABLESPACE_NAME, FILE_NAME, FILE_ID
FROM DBA_temp_FILES
WHERE TABLESPACE_NAME = 'TMP';
TABLESPACE_NAME FILE_NAME FILE_ID
TMP C:\ORACLEXE\ORADATA\XE\TEMP1.DBF 2
SELECT TABLESPACE_NAME, FILE_NAME, FILE_ID
FROM DBA_temp_FILES
WHERE TABLESPACE_NAME = 'TMP';
TABLESPACE_NAME FILE_NAME FILE_ID
TMP C:\ORACLEXE\ORADATA\XE\TEMP1.DBF 2
Comments
Post a Comment