permanent space availability,space,permanent space

General

permanent space availability,space,permanent space

What will be present if no permanent space is available in the DB and why? -

a. Views and Macros       

b. views only       

c. Macros only.

4 REPLIES
N/A

Re: permanent space availability,space,permanent space

Again, not sure that I understand what you asking for.

All DDLs need some minor space to be stored in the DB. So if you do not have any perm space assigned to a DB you can not store any VIEW and MACRO in a DB.

Re: permanent space availability,space,permanent space

The space used for macros, views, and triggers definitions is NOT part of the the owner PERM space.

From the docco:

A database or user with no PERM space can still own views, macros, and triggers

(Database Administration, CHAPTER 4 Space)

HTH.

Cheers.

Carlos.

Re: permanent space availability,space,permanent space

A database without PERM space can not store tables,however it can store views & Macros because they are physically stored in the data dictionary PERM space.

Stalin

N/A

Re: permanent space availability,space,permanent space

yes, I was wrong.

Confused myself with the empty table space requirements.