Segment creation immediate on a global temporary table

SQL Navigator
1

Hi

When I do an extract-ddl of a temporary table I get a result like this :

The problem is that when I launch the resulted statement on (another) database, I get the error : ORA-14451

Regards

Martin

2

Hi Martin,

Did you run the statement in older (10g) database? which version of database are you running this statement?

Thanks,

Michael

3

Hi Michael

Our environment is :

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

CORE 11.2.0.3.0 Production

TNS for HPUX: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

Regards

Martin

4

Hi Martin,

Thanks for your feedback.

we are still investigating for this, and we have known story SQLNAV-1883 for Segment creation issue.

Regards,

Michael