What is the difference between temporary and permanent tablespaces




















Your comment on this answer: Email me at this address if a comment is added after mine: Email me if a comment is added after mine Privacy: Your email address will only be used for sending these notifications. A temporary tablespace It is used for temporary objects such as sort structures. Permanent tablespaces It is used to store those objects meant to be used as the true objects of the database.

Your answer. Privacy: Your email address will only be used for sending these notifications. Answers A temporary tablespace is used for temporary objects such as sort structures while permanent tablespaces are used to store those objects meant to be used as the true objects of the database.

Your Comment. More Software Questions.. What is the inputsplit in map reduce software? Give an example? What happens if a start method is not invoked and the run method is directly invoked? What are the minimum system requirements to run Photoshop?

There is no theoretical maximum limit to the number of tablespaces in a tablespace group, but it must contain at least one. The group is implicitly dropped when the last member is removed. The last member of a group cannot be removed if the group is still assigned as the default temporary tablespace. In this example the following must be done to remove the last member from the group. Tablespace groups share the same namespace as tablespaces so a group and tablespace cannot share the same name.

Aggregator Privacy policy.



0コメント

  • 1000 / 1000