![]() (Note: you can be connected to any library in doing this. If it is not, you should be able to see it in the util a/17/10/2 Merged file list (which gets its values from the file_list.xxx template in the $aleph_root/tab/ directory - in addition to the $data_root/file_list).Īlso, you can do the following SQL. Don't forget about '' on both sides of string. Then provide table text that should be part of table name. Option 1: Filter First option is to use object filter. (Optional) Click a column name to sort the data by that column. In this tutorial I will show you 3 quick ways to find a table by a name using Oracle SQL Developer. The data for the table appears on the Data subtab. To open the Find Database Object pane, right-click a connection name in the Connections navigator and select Find DB Object. To clear filter right click on connection and select Clear Filter. Oracle SQL Developer will show you only tables with names fitting this criteria. ![]() Tab Groups are shown concurrently in the SQL Developer desktop display Optimizing the Preferences By default, as you open a database object in SQL Developer, it will cause any previously opened object to close. If the table or index is in the library's $data_root/file_list, that should show you the tablespace. In the object pane, click the Data subtab. Option 1: Filter First option is to use object filter. Right click on the table editor tab and ask for the new document tab group. ![]() How can I tell what tablespace a particular Oracle table or index resides in?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |