You are running 12.1.0.2. You only have shared UNDO in this version. PDB local
undo is available in 12.2.
thx
jpm
Sent from my iPhone
On Jan 15, 2017, at 12:34 PM, Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
wrote:
Hi,
I have a container and I have one pdb in Oracle 12c.
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
0
PL/SQL Release 12.1.0.2.0 - Production
0
CORE 12.1.0.2.0 Production
0
TNS for Linux: Version 12.1.0.2.0 - Production
0
NLSRTL Version 12.1.0.2.0 - Production
0
Connected as sysdba and as sysdba@instpdb I see these parameters related to
undo.
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
temp_undo_enabled boolean FALSE
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS2
Note : Look that I don´t see the local_undo_enabled parameter .
I am doing a delete * from table and 7gb of tablespace undo is not being
enough.
It delete 13.000.000 lines and takes more then 15 minutes.
It is not a production environment and I don´t want to save all data to
recover in the future.
I would like to know how to check if the UNDO option is on or off
and
How to disable the UNDO option in order to Oracle write the minimum in the
undo tablespace.
Regards
Eriovaldo