Home » RDBMS Server » Server Administration » Re: Rollback and temporary data file
Re: Rollback and temporary data file [message #49618] Thu, 31 January 2002 03:19
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
When you create a user, you assign a default tablespace and a temporary tablespace. That user will be using that temporary talespace assigned to it.

As for Rollback, it uses any available one. Unless, you are specifying which rollback segment to use, it will grab any available one.

Hope this helps.

Report message to a moderator

Previous Topic: Re: Howto determine which archive log is currently being written to?
Next Topic: Re: ora-27101
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 11:46:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.