OraFAQ Forum: Backup & Recovery » Temp Tablespace Backup in Oracle 9i.

Home » RDBMS Server » Backup & Recovery » Temp Tablespace Backup in Oracle 9i.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Temp Tablespace Backup in Oracle 9i. [message #54943]

Tue, 17 December 2002 15:47

Latish Ch
Messages: 1
Registered: December 2002

Junior Member

Just a question , Is there any architecural changes done in oracle 9i with respect to TEMP Tablespace backup?

Oracle 8i.

1) Query select ts#,name from v$tablespace shows all the tablespace numbers and names.
Query select name from v$datafile where ts#='TEMP Tablespace number' shows the Datafile associated with Temp Tablespace.
And the datafile exists in the data folder of oracle.

Oracle 9i.

2) Query select ts#,name from v$tablespace shows all the tablespace numbers and names.
Query select name from v$datafile where ts#='TEMP Tablespace number' shows "NO ROWS SELECTED".
But the Datafile associated with Temp tablespace exists on disk.

Please let me know of any configuration changes in Oracle 9i with backups of TEMP Tablespace.

I'm sure of some configuration change, just trying to find out the reason or cause for this , if at all done
and also let me know of any articles available from oracle on this.

Regards,
Latish

Report message to a moderator

Re: Temp Tablespace Backup in Oracle 9i. [message #54950 is a reply to message #54943]

Wed, 18 December 2002 11:32

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

first,
WHY DO U NEED TO BACKUP A TEMP TABLESPACE?
There is NO USE of it

Report message to a moderator

Re: Temp Tablespace Backup in Oracle 9i. [message #54952 is a reply to message #54943]

Wed, 18 December 2002 12:16

N.A.Jam
Messages: 1
Registered: December 2002

Junior Member

8i introduced locally managed tablespace. Oracle created a new filetype called tempfiles to allow tablespaces set to temporary to take advantage of locally manager tablespace. Try selecting from v$tempfile and see if you find what you were looking for.

This is my understanding and any comments or corrections are welcome.

Cheers everyone.

Report message to a moderator

Previous Topic:	Corrupt block header, no backup, need media recovery
Next Topic:	Removing obsolete archived logs from RMAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 02:43:27 CDT 2025