My Oracle Support Banner

Data Maskin Script Generation Shows False Resource Warnings about Quota on TEMP TABLESPACE (Doc ID 1539540.1)

Last updated on MAY 01, 2020

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.2.0 and later
Information in this document applies to any platform.

Goal

When you generate some data masking scripts with  em12c v. 12.1.0.2.
Since the update to Oracle Enterprise Manager 12c Release 2 Plug-in Update 1 and deployment of database plugin 12.1.0.3, data masking scripts shows resource warning for temp tablespaces.

Data masking script generation completed with warnings. See the Impact Report for details.
Printing Impact Report...

Object Name Object Type Message Severity Message Type Message
<USERNAME> USER RESOURCE WARNING Plan Insufficient tablespace quota for User <USERNAME> on Tablespace TEMP.

Some operations for User <USERNAME> being performed in Tablespace TEMP may fail.

Increase tablespace quota for User <USERNAME> on Tablespace TEMP to at least 5120KB.

 



The temp tablespace has already a size of 3GB.
Currently, if ignore these kind of warnings,everything is fine. This sr has just informational character.
So let us close this sr and you can redirect this topc to someone at oracle who is interested in it or responsible for data masking.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.