here is my Topic to throw your tips/ideas/suggestions...
Situation:I have created a standby database.Tempfile created in primary is missing but tablespace is there.
I could confirm from dba_tablespaces...(Hope I no need to say tempfile is Loaclly managed).
MY Qtn:when we create datafile in primary and apply archive logs to standby...it fails asking datafile
So we create that datafile...by alter database create 'datafile' as 'datafile';it works.
When I create tempfile in primary,alter the user to take that tablespace as temporary,
applied archives to standby...Till this fine.
But tempfile is missing while querying $tempfile.
Sorting fails saying temp tablespace is empty.
I tried to create tempfile as 'alter tablespace tempts add tempfile 'XXXXXX' reuse;
fails saying cannot find the file.
I tried 'alter tablespace tempts add tempfile 'newfile" size xxxxm; works.
how..WHY.Please throw some lights.Ofcourse database v8.1.6 in sunOS