i got the alert log file but it is very huge
can u joins this session so that i can show you
NO, if you don't get any answer open a SR.
You won't get any correct answer if you don't cooperate. We told you for information that you didn't show like "dir C:\", post alert.log. Both information is necessary.
when Niket Kumar told you for alert.log you post trace (why?), when i told you about dir c:\ you ignored me....
Error Description: cannot add file string – file already part of database
Error Cause: During CREATE or ALTER TABLESPACE, a file being added is already part of the database.
How to Solve: Use a different file name. You can't use the same name for an existing datafile
is it ok
alter database tempfile 'C:\APP\VSHADMIN\ORADATA\ORCL01\TEMP03.DBF' autoextend on;
but when i fired the statement
select TEMPORARY_TABLESPACE from dba_users where username='DATAWAREHOUSE';
atlest it should point to temp02,03 etc
how to assign temp02 to datawarehouse?
Edited by: 896398 on Jan 22, 2013 1:29 AM
Edited by: 896398 on Jan 22, 2013 1:30 AM