# Toad create records/datasets **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [August 28, 2024, 8:59pm UTC](https://forums.toadworld.com/t/toad-create-records-datasets/59876 "2024-08-28T20:59:58Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![phoenix](https://avatars.discourse-cdn.com/v4/letter/p/0ea827/32.png) [@phoenix](https://forums.toadworld.com/u/phoenix)\ **Post date:** [August 28, 2024, 8:59pm UTC](https://forums.toadworld.com/t/toad-create-records-datasets/59876/1 "2024-08-28T20:59:58Z")
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. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [August 28, 2024, 9:07pm UTC](https://forums.toadworld.com/t/toad-create-records-datasets/59876/2 "2024-08-28T21:07:16Z")
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. ---
**Author:** ![phoenix](https://avatars.discourse-cdn.com/v4/letter/p/0ea827/32.png) [@phoenix](https://forums.toadworld.com/u/phoenix)\ **Post date:** [August 28, 2024, 9:13pm UTC](https://forums.toadworld.com/t/toad-create-records-datasets/59876/3 "2024-08-28T21:13:10Z")
Yes the table is already created. How do you open the schema browser? ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [August 28, 2024, 9:15pm UTC](https://forums.toadworld.com/t/toad-create-records-datasets/59876/4 "2024-08-28T21:15:05Z")
Click here ![image](https://global.discourse-cdn.com/quest/original/3X/8/b/8b63acf63c7381d48bc8209299376592f6e86e58.png) ---
**Author:** ![phoenix](https://avatars.discourse-cdn.com/v4/letter/p/0ea827/32.png) [@phoenix](https://forums.toadworld.com/u/phoenix)\ **Post date:** [September 5, 2024, 8:19pm UTC](https://forums.toadworld.com/t/toad-create-records-datasets/59876/5 "2024-09-05T20:19:57Z")
For some the table is missing. ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [September 5, 2024, 8:23pm UTC](https://forums.toadworld.com/t/toad-create-records-datasets/59876/6 "2024-09-05T20:23:51Z")
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. ---
**Author:** ![phoenix](https://avatars.discourse-cdn.com/v4/letter/p/0ea827/32.png) [@phoenix](https://forums.toadworld.com/u/phoenix)\ **Post date:** [September 5, 2024, 8:45pm UTC](https://forums.toadworld.com/t/toad-create-records-datasets/59876/7 "2024-09-05T20:45:29Z")
It already exists. Not sure why the schema browser is not seeing it. ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [September 6, 2024, 12:24pm UTC](https://forums.toadworld.com/t/toad-create-records-datasets/59876/8 "2024-09-06T12:24:15Z")
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. ![image](https://global.discourse-cdn.com/quest/original/3X/f/1/f15b40c161d1a5ce6db1166c4eb296ac383a0a75.png) ---
**Author:** ![phoenix](https://avatars.discourse-cdn.com/v4/letter/p/0ea827/32.png) [@phoenix](https://forums.toadworld.com/u/phoenix)\ **Post date:** [September 6, 2024, 2:27pm UTC](https://forums.toadworld.com/t/toad-create-records-datasets/59876/9 "2024-09-06T14:27:10Z")
It does not look like I have any filters. ![toad_9-6-2024_1](https://global.discourse-cdn.com/quest/original/3X/b/b/bbe2dc027fdf1211ff20bc778358b048537920c2.jpeg) ![toad_9-6-2024_2](https://global.discourse-cdn.com/quest/original/3X/9/3/9315c1898a3184d9922cb7fba7f7aa763a20439f.jpeg) ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [September 18, 2024, 8:18pm UTC](https://forums.toadworld.com/t/toad-create-records-datasets/59876/10 "2024-09-18T20:18:50Z")
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' ---
**Author:** ![phoenix](https://avatars.discourse-cdn.com/v4/letter/p/0ea827/32.png) [@phoenix](https://forums.toadworld.com/u/phoenix)\ **Post date:** [September 18, 2024, 8:49pm UTC](https://forums.toadworld.com/t/toad-create-records-datasets/59876/11 "2024-09-18T20:49:16Z")
Sorry was using a DB link. Did not realize that was a problem. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [September 18, 2024, 9:01pm UTC](https://forums.toadworld.com/t/toad-create-records-datasets/59876/12 "2024-09-18T21:01:43Z")
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. ![image](https://global.discourse-cdn.com/quest/original/3X/e/1/e17c389e020309d3b4f4f3b796471fb9e8f80ba2.png) ---
**Author:** ![phoenix](https://avatars.discourse-cdn.com/v4/letter/p/0ea827/32.png) [@phoenix](https://forums.toadworld.com/u/phoenix)\ **Post date:** [September 18, 2024, 9:38pm UTC](https://forums.toadworld.com/t/toad-create-records-datasets/59876/13 "2024-09-18T21:38:24Z")
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. ---
**Author:** ![phoenix](https://avatars.discourse-cdn.com/v4/letter/p/0ea827/32.png) [@phoenix](https://forums.toadworld.com/u/phoenix)\ **Post date:** [September 18, 2024, 9:47pm UTC](https://forums.toadworld.com/t/toad-create-records-datasets/59876/14 "2024-09-18T21:47:01Z")
Weird when I hit f4 it is saying table does not exist. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [September 18, 2024, 9:54pm UTC](https://forums.toadworld.com/t/toad-create-records-datasets/59876/15 "2024-09-18T21:54:22Z")
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.