Does toad oracle have any tools for creating records/datasets? I need to create about 1k records for testing. Not sure what the best way to do this is.
If the table is already created, right-click on it in the Schema Browser and choose Data -> Generate.
That will launch a wizard where you can put random data in your table.
Yes the table is already created. How do you open the schema browser?
Click here
For some the table is missing.
You will need to create the tables, first. You can either construct the CREATE TABLE statement yourself and execute it in the Editor or you can use Toad's Create Table window. See the Database > Create menu on Toad's main menu.
It already exists. Not sure why the schema browser is not seeing it.
Do you have any filters set? If the circled icon is red in color instead of gray or if the circled edit box has any text other than * then a filter is applied which will limit the tables you see.
Are you sure that the missing tables are really tables in the same schema that you are logging in as?
try this in the editor for one of the missing tables, substituting your table name....
select owner, object_type
from all_objects
where object_name = 'YOUR_TABLE_NAME_HERE'
Sorry was using a DB link. Did not realize that was a problem.
Ah, ok. In that case, they aren't really missing. They are just in a different database.
If you want to see some info on the table through a DB Link, you can type the table name and db link into the editor, then hit F4 and you can get a describe window for the table.
Can you use the data generator in this case since I am using a DB link? Couldn't figure out a way to do so without copying over data to my schema.
Weird when I hit f4 it is saying table does not exist.
You can turn on spool SQL to see what SQL Toad runs to try to find the object. That should give you a clue as to why it's not found. You might have to run some of those SQLs in the editor to play detective. If you see something you don't understand, let us know.
Main Menu -> Database -> Spool SQL -> Spool to screen.