Reference table slow problem

[Azhar]

Dear Support,

When i want to create table and add references tables. Then it take too much time.
Possible it is querying ALL_Tables i have large database with 25-30 schema's.
Is there any possibility that it will populate only current user tables
Regards,

Azhar Hussain

 

[Marco Kalter]

Are you talking about the creation of foreign key constraints?

 

[Azhar]

Yes, while creating new foreign key constraint, when we type table name in referencing_table it take too much time to populate.

 

[Marco Kalter]

All tables for which you have privileges will be displayed, and the only way to restrict them is to have fewer object or system privileges (e.g. revoke a DBA role).

We'll probably restrict the list to the current schema in the next version.

 

[Azhar]

I give only connect and resource rights but it always query fro m all_tables.

 

[Marco Kalter]

That's true, but the number of tables will be restricted by your privileges.