TEMPFILE for discussion
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: TEMPFILE for discussion

  1. #1
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    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.

  2. #2
    Join Date
    Feb 2002
    Location
    http://db-migration.co.in
    Posts
    50
    Hi,

    Media recovery doesnot recognises tempfiles.

    Prakash

  3. #3
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330

    tempfile

    Because it is locally managed right?.
    Any other tips please..
    Thanks.
    Thanigai.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330

    tempfile

    I am lost......
    Temporary means because it is managed locally otherwise
    managed in data dict..(Permanent)...Right.
    Thanks.
    Thanigai.

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width