Experts,
When i tried to get user metadata from pdb i am getting an additional local temporary tablespace. I need to create the same user in another database.
Kindly help me how would to achieve below SQL in another DB - Oracle is not allowing to create local temporary tablespace in the name of TEMP_DEL
ALTER USER "XXXXX" LOCAL TEMPORARY TABLESPACE "TEMP_DEL"
SQL> select DBMS_METADATA.GET_DDL('USER','XXXXX') from dual;
DBMS_METADATA.GET_DDL('USER'XXXXX')
--------------------------------------------------------------------------------
CREATE USER "XXXXX" IDENTIFIED BY VALUES 'S:0FBD6E74D88D4FA33CED9E3557D18D
D61E598B935114E820DADB8E7B5FFB;T:8035FEBABBDA50D3C4C026FB259620CADCFA58D30F88E19
A0D4664FCB10C5EF69D99561DA3AE2DAB7033920E0F298E4493ACCE7BED0F8B752B66A4D5B861035
F721597B5C095F67F5BCDB078A10A8D99'
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
ALTER USER "XXXXX" LOCAL TEMPORARY TABLESPACE "TEMP_DEL"
Question is
How would i get metadata of this TEMP_DEL
DB Version is 12.2