After using RMAN to duplicate a database, everything is fine except the locally managed temporary tablespace seems to be missing. Look at the following query. Is this a bug?

SQL> select * from dba_tablespaces where tablespace_name='BIG_TEMP';

TABLESPACE_NAME INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING EXTENT_MAN ALLOCATIO PLU
-------------------- -------------- ----------- ----------- ----------- ------------ ---------- --------- --------- --------- ---------- --------- ---
BIG_TEMP 1048576 1048576 1 0 1048576 ONLINE TEMPORARY NOLOGGING LOCAL UNIFORM NO

1 row selected.

SQL> select * from DBA_TEMP_FILES;

no rows selected

SQL>