Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of psaptemp table space?if we delete all the
data files in temporary table space will oracle throws any
error?
- 2 Answers
- 22154 Views
- I also Faced
- E-Mail Answers
Answer Posted / shashisy
A temporary tablespace is mainly required for the
intermediate storage of temporary data during certain
database actions, for example:
Sorting/aggregation with CREATE INDEX, SELECT ...
DISTINCT, ORDER BY, GROUP BY, UNION, INTERSECT, MINUS (when
the memory area defined using SORT_AREA_SIZE is insufficient)
If data files are deleted it throws following err
ORA-01652: unable to extend temp segmen
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is the information derived from OSS notes?
How many types of work processes are there in sap ?
what is the difference between with core
In the Sap Easy Access Menu I see the menu System -> User Profiles ->Own Data. Other options Hold Data is to keep data values that you have entered in a field of an application for the duration of the session; SET DATA not to overwrite the data and DELETE DATA to delete the set data. Can somebody explain me the Hold Data, Set Data and Delete Data with examples, i mean giving an example of fields?
Transport request types and its syntax?
Which table contains the details related to Q defined in SPAM? Is there a way to revert back the Q defined? If yes, How?
If job is slow?
Explain what is heterogenous system copy and homogenous system copy ?
What will you observe in st06?
If I want only transaction data to be copied.What profile should I select, while doing local client copy within the same apllication server. Else is there any other way to perform above task?
How to create RFC CONNECTION between production server and Global trade system. what prerequsite we need for this.
While doing implementation do you get any issues?
Which transport directory is used to implement support package and add-ons?
How client refresh is different than client copy?
What is an ‘ok’ code? What are the differences an ‘ok’ code to a ‘t-code’?
