Toad World® Forums

Question on schema with many objects

Hello,

when opening a schema with many objects; how can i hide ddl and all kind of other informations on the left hand side?

I dont need all these information and currently my schema keeps on processing and doenst finish loading,

Please help,

Thanks,

Yael Fruchterman

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2013/06/20/speed-up-toad-for-oracle-s-schema-browser.aspx

Whatever tab is active on the RHS will get automatically populated as you click around on the left.

The script tab is one of the slower ones to load, so try changing to another tab on the right.

If you don’t want to see the RHS at all (and skip all that processing), hit F12. (You can always F12 again to bring it back). Even with the RHS missing, you
can still do a lot of things with the objects on the left by right-clicking on them. Or if you want to see detail on just one of those objects you can click F4 on it.

-John

From: yael.fruchterman [mailto:bounce-yaelfruchterman@toadworld.com]

Sent: Tuesday, October 15, 2013 1:13 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Question on schema with many objects

Question on schema with many objects

Thread created by yael.fruchterman

Hello,

when opening a schema with many objects; how can i hide ddl and all kind of other informations on the left hand side?

I dont need all these information and currently my schema keeps on processing and doenst finish loading,

Please help,

Thanks,

Yael Fruchterman

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Hi John,

Thank you for your prompt reply.

In my schema I need to see all the objects and their fields that open up on the RHS when clicking on the object. However I do not need to see their modification dates…

In my previous version, 11.6, I could disable some option in the toad options but in version 12 I can’t find this option. I need this feature because due the size of the schema it doesn’t finish processing.

I thought you might be able to tell where it can be found in version 12

Thanks,

Yael

Sent from my iPad

On Oct 15, 2013, at 2:22 PM, “John Dorlon” bounce-jdorlon@toadworld.com wrote:

RE: Question on schema with many objects

Reply by John Dorlon
Whatever tab is active on the RHS will get automatically populated as you click around on the left.

The script tab is one of the slower ones to load, so try changing to another tab on the right.

If you don’t want to see the RHS at all (and skip all that processing), hit F12. (You can always F12 again to bring it back). Even with the RHS missing, you
can still do a lot of things with the objects on the left by right-clicking on them. Or if you want to see detail on just one of those objects you can click F4 on it.

-John

From: yael.fruchterman [mailto:bounce-yaelfruchterman@toadworld.com]

Sent: Tuesday, October 15, 2013 1:13 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Question on schema with many objects

Question on schema with many objects

Thread created by yael.fruchterman

Hello,

when opening a schema with many objects; how can i hide ddl and all kind of other informations on the left hand side?

I dont need all these information and currently my schema keeps on processing and doenst finish loading,

Please help,

Thanks,

Yael Fruchterman

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

If you are talking about tables….

Click the ‘Filter tables’ button (looks like a funnel). Uncheck “Load Date Created and Altered”.

In Toad 12.1, this code has been optimized and it runs much faster.

From: yael.fruchterman [mailto:bounce-yaelfruchterman@toadworld.com]

Sent: Tuesday, October 15, 2013 7:07 PM

To: toadoracle@toadworld.com

Subject: Re: [Toad for Oracle - Discussion Forum] Question on schema with many objects

Re: Question on schema with many objects

Reply by yael.fruchterman

Hi John,

Thank you for your prompt reply.

In my schema I need to see all the objects and their fields that open up on the RHS when clicking on the object. However I do not need to see their modification dates…

In my previous version, 11.6, I could disable some option in the toad options but in version 12 I can’t find this option. I need this feature because due the size of the schema
it doesn’t finish processing.

I thought you might be able to tell where it can be found in version 12

Thanks,

Yael

Sent from my iPad

On Oct 15, 2013, at 2:22 PM, “John Dorlon” bounce-jdorlon@toadworld.com wrote:

RE: Question on schema with many objects

Reply by John Dorlon

Whatever tab is active on the RHS will get automatically populated as you click around on the left.

The script tab is one of the slower ones to load, so try changing to another tab on the right.

If you don’t want to see the RHS at all (and skip all that processing), hit F12. (You can always F12 again to bring it back). Even with the RHS missing, you
can still do a lot of things with the objects on the left by right-clicking on them. Or if you want to see detail on just one of those objects you can click F4 on it.

-John

From: yael.fruchterman [mailto:bounce-yaelfruchterman@toadworld.com]

Sent: Tuesday, October 15, 2013 1:13 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Question on schema with many objects

Question on schema with many objects

Thread created by yael.fruchterman

Hello,

when opening a schema with many objects; how can i hide ddl and all kind of other informations on the left hand side?

I dont need all these information and currently my schema keeps on processing and doenst finish loading,

Please help,

Thanks,

Yael Fruchterman

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Hi John,

this was exactly what I was looking for.

Thank you very much,

Yael

On Wed, Oct 16, 2013 at 9:18 AM, John Dorlon bounce-jdorlon@toadworld.com wrote:

RE: Question on schema with many objects

Reply by John Dorlon
If you are talking about tables….

Click the ‘Filter tables’ button (looks like a funnel). Uncheck “Load Date Created and Altered”.

In Toad 12.1, this code has been optimized and it runs much faster.

From: yael.fruchterman [mailto:bounce-yaelfruchterman@toadworld.com]

Sent: Tuesday, October 15, 2013 7:07 PM

To: toadoracle@toadworld.com

Subject: Re: [Toad for Oracle - Discussion Forum] Question on schema with many objects

Re: Question on schema with many objects

Reply by yael.fruchterman

Hi John,

Thank you for your prompt reply.

In my schema I need to see all the objects and their fields that open up on the RHS when clicking on the object. However I do not need to see their modification dates…

In my previous version, 11.6, I could disable some option in the toad options but in version 12 I can’t find this option. I need this feature because due the size of the schema
it doesn’t finish processing.

I thought you might be able to tell where it can be found in version 12

Thanks,

Yael

Sent from my iPad

On Oct 15, 2013, at 2:22 PM, “John Dorlon” bounce-jdorlon@toadworld.com wrote:

RE: Question on schema with many objects

Reply by John Dorlon

Whatever tab is active on the RHS will get automatically populated as you click around on the left.

The script tab is one of the slower ones to load, so try changing to another tab on the right.

If you don’t want to see the RHS at all (and skip all that processing), hit F12. (You can always F12 again to bring it back). Even with the RHS missing, you
can still do a lot of things with the objects on the left by right-clicking on them. Or if you want to see detail on just one of those objects you can click F4 on it.

-John

From: yael.fruchterman [mailto:bounce-yaelfruchterman@toadworld.com]

Sent: Tuesday, October 15, 2013 1:13 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Question on schema with many objects

Question on schema with many objects

Thread created by yael.fruchterman

Hello,

when opening a schema with many objects; how can i hide ddl and all kind of other informations on the left hand side?

I dont need all these information and currently my schema keeps on processing and doenst finish loading,

Please help,

Thanks,

Yael Fruchterman

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.