My Oracle Support Banner

OEM13C: DB_CLONE_MANAGEMENT : createFullClonePDB Maked Completed Sucessful Even After Errors In Job Step Run Non-CDB to PDB SQL Script With Error "ORA-01652: unable to extend temp segment by 128 in tablespace TEMP" (Doc ID 2753235.1)

Last updated on MARCH 03, 2021

Applies to:

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

Symptoms

In Cloud Control Enterprise Manager using db_clone_management, When running the createFullClonePDB command completed successful but the below errors seen in job step Non-CDB to PDB SQL Script.

Command Snippet :

$ emcli db_clone_management -createFullClonePDB -target_name="<SOURCE_DBNAME>" -target_type="oracle_database" -input_file="data:/home/oracle/clone.properties"

Job Steps Log for Job :Run Non-CDB to PDB SQL Script :

1:SQL Script:Command
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Feb 15 15:19:31 2021
Version 19.8.0.0.0
ERROR at line 1:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
ORA-06512: at line 12
ORA-06512: at line 12

SQL> select name,open_mode from v$pdbs;

NAME           OPEN_MODE     RES
-------------------- -----------------
RACTESTPDB READ WRITE    YES

Cause

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
Symptoms
Cause
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.