-
Hi Grus,
here is my Topic to throw your tips/ideas/suggestions...
Topic: Tempfile
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
'xxxxxxxxx' missing.
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,
switch logfiles..
and
applied archives to standby...Till this fine.
But tempfile is missing while querying $tempfile.
Sorting fails saying temp tablespace is empty.
Good.
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
Thanks.
Thanigai.
-
Hi,
Media recovery doesnot recognises tempfiles.
Prakash
-
tempfile
Because it is locally managed right?.
Any other tips please..
Thanks.
Thanigai.
-
Re: tempfile
Originally posted by thanigai
Because it is locally managed right?.
Any other tips please..
Thanks.
Thanigai.
No, because it's temporary.
Jeff Hunter
-
tempfile
I am lost......
Temporary means because it is managed locally otherwise
managed in data dict..(Permanent)...Right.
Thanks.
Thanigai.
-
Re: tempfile
Originally posted by thanigai
I am lost......
Temporary means because it is managed locally otherwise
managed in data dict..(Permanent)...Right.
Thanks.
Thanigai.
No. See http://technet.oracle.com/docs/produ...ary.htm#434051 and http://technet.oracle.com/docs/produ...aces.htm#10643 for details.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|