All Forums General
pareshgupta 3 posts Joined 01/12
19 Jan 2012
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.

ulrich 816 posts Joined 09/09
19 Jan 2012

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.

 

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

CarlosAL 512 posts Joined 04/08
19 Jan 2012

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.

Stefans 38 posts Joined 02/12
22 Feb 2012

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

Stalin

ulrich 816 posts Joined 09/09
22 Feb 2012

yes, I was wrong.

Confused myself with the empty table space requirements.

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

You must sign in to leave a comment.