Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace?
- 2 Answers
- 22650 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
1.Temporary tablespace is locally managed tablespace
Permanent tablespace is dictionary managed tablespace
2. when an extent is allocated or freed for reuse changes
occurs in tables.In case of Temporary tablespace changes
happen in bitmaps but in Permanent tablespace System Tables
gets updated.
3. Temporary Tablespace automatically tracks adjacent free
space.
| Is This Answer Correct ? | 7 Yes | 18 No |
Post New Answer View All Answers
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
Give two methods you could use to determine what DDL changes have been made.
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
Differentiate between transaction type and transaction source? : oracle accounts receivable
What is autocashrule set? : oracle accounts receivable
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
Where in the Oracle directory tree structure are audit traces placed?
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
Can we modify approve purchase order?if yes what is navigation?
which one is currently in used software cmpanies.
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
What is the difference between recovery and restoring of the oracle database?
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
Why more redos are generated when the oracle database is in begin backup mode?
