Trouble creating table

Hi, I’m brand new to TOAD and have just tried creating a table.

Went through the Create Table dialog defining columns and data types, pressed the OK button and the script ran. At that point I couldn’t see the table in the Schema browser. Tried again and got an error that the object already existed.

Next step… I went to the Object Palette. Sure enough the table is there, and I was abel to load some data into it, but it still does not appear in the Schema. I’ve obviously left something out but what happens next? Is it possible to copy / transfer / edit that table so it appears in the Schema? Or should I delete it (how best to do that) and then re-create it?

Morning Dennis,

Welcome to Toad.

I assume version 10 of Toad, I'm using 10.6 specifically for what
follows:

First of all, go to view->toad options, select oracle->transactions.
Make sure that "commit after every statement" is deselected. It's not
part of your problem, but it will save you much grief in future! :wink:

Went through the Create Table dialog defining columns and
data types, pressed the OK button and the script ran. At
that point I couldn't see the table in the Schema browser.

Next, select schema browser -> left hand side. Make sure that you have
selected both options to "refresh the schema browser" - after an object
is created and after an object is altered. That causes the left side to
refresh when you create or alter an object.

OK your way out of options.

Tried again and got an error that the object already existed.

Yes, the table exists already because you ran the script. Unless you
received an error when you ran it, the script worked fine. It's just you
need to automatically (as above) or manually refresh the schema browser.
To do it manually, there are three buttons above the right hand side of
the SB. These buttons have "circular" arrows on them plus another arrow
beneath (Sorry, I can't do a screen shot at present!)

The first refreshes everything in the LHS. If you hover over it, the
hint says "Refresh all objects". That isn't the one you want!

The middle button's hint is "Refresh current list *(Left side of
browser)" This is the one you want. Assuming you have the list of tables
open on the LHS, click this button to refresh the list of tables, et
viola (as the French musician would say), your table will appear.
Assuming, of course, that you have the correct user selected AND you
don't have filters set on table names that will prevent your new table
from showing up.

The other button refreshed the RHS of the SB.

Is it possible to copy / transfer / edit that table so it appears in
the
Schema? Or should I delete it (how best to do that) and then
re-create it?
No, don't delete it. The table is there in the database, it's just
not showing up in Toad for one or other of the reasons above.

HTH

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Seems that it was a refresh issue.

I exited TOAD, opened it up again and the tables appeared in the Schema.

Which raises another question… When a table is created how do you refresh the view to see it in the Schema, without having to get out of the application? Message was edited by: ToadNewbie

Message was edited by: ToadNewbie

Hi,

what version are you using? although if it’s v9 or even v10, schema browser I
think is similar. if you go to the schema browser regardless of how you’re
browser style is, you’ll see this --> . In your case, if you clicked the
middle(with #1 on it) and you’re on the tables view that time it would’ve
refreshed the list of tables.

Hello,

I was wondering if there was a way to copy a table within a schema? I have similar tables, and thought it might be easier to copy one and edit the criteria, but I haven’t seen any option to do that?

schema browser -> tables -> right hand mouse menu -> create like