Skip to Main Content

SQL Developer Data Modeler

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!

Generating FK index, PK index and Unique constraint index

user11377561Apr 1 2013 — edited Apr 2 2013
Under preferences, DDL, I have Automatic Index Generation setup for primary, foreign key and unique constraint. SDDM is generating these automatically in the DDL with the name of the FK having an X at the end of it. e.g., if the name of the fk is <aaaa>FK1, it is generating the index name as <aaaa>FK1X. Is this default behavior? Is there a way to specify a template for the automatic generation of this index (i.e., I would like to generate the index with the same name as the FK itself without the X at the end of the index name).

Please advise how this can be done.

Thanks!

Comments

Srini Chavali-Oracle
It depends - most, if not all, database patches require that the database be shut down. Check the README accompanying each patch.

HTH
Srini
user62721
Hi,

from 11g, some patches are online
$ opatch query -is_online_patch
Regards
Srini Chavali-Oracle
Good stuff ! More details in

Gathering Patch details before applying using Opatch Query option [ID 1510747.1]

HTH
Srini
Osama_Mustafa
including to information posed by other check
RDBMS Online Patching Aka Hot Patching [ID 761111.1
1005886
Thank you guys for helping me in patching
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 30 2013
Added on Apr 1 2013
5 comments
939 views