Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

4.2 EA2 How to influence DDL generation in sql tab of table

GünterFeb 21 2017 — edited Feb 22 2017

Is it possible to influence the generation of the table ddl in the sql-tab ?

In previous releases it was possible to influence this by custom calls to DBMS_METADATA.set_transform_param e.g. :

EXECUTE dbms_metadata.set_transform_param(transform_handle=>dbms_metadata.session_transform, NAME=>'SEGMENT_ATTRIBUTES', VALUE=>TRUE);

Regards Günter

This post has been answered by Gaz in Oz on Feb 21 2017
Jump to Answer

Comments

Markus Flechtner

Hi,

unfortunately, that's not possible.

In any case, the Non-CDB will end up as a PDB in a CDB.

However, you can "reuse" the existing datafiles by plugging in the Non-CDB as a PDB

You'll find more information on migrating a Non-CDB -> PDB in the following MOS-Notes

- MOS-Note: How to Convert Non-CDB to PDB (Doc ID 2288024.1)

- How to Convert Non-CDB to PDB Database in 12c - Testcase (Doc ID 2012448.1)

and in the documentation (Administrator’s Guide):

- 7.4 Cloning a Non-CDB : https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/cloning-a-pdb.html#GUID-B5D803D4-939B-4D0A-B684-5A1089EA4618

- 9.3 Adopting a Non-CDB as a PDB : https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/plugging-in-a-pdb.html#GUID-EE58804F-A999-4F7C-93DE-D641B3C1047B

HTH

Markus

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 21 2017
Added on Feb 21 2017
1 comment
244 views