The November edition of DBArtisan tips and techniques Webinar covered three tips for using DBArtisan.
- Using Projects to organize your work
- Using the visual Query Builder
- Space Management using DBArtisan
You can view a recording of the event here: November Tips and Tricks
A DBArtisan project generally includes SQL script files that you can maintain and create in unison with your database administration and development cycle. Projects can also contain subfolders. You can create projects manually by inserting existing SQL script files. You can also create projects automatically by reverse-engineering a database schema or an existing version control project.
The Query Builder provides a visual display of your queries as you construct them. You can run Query Builder against any registered datasource. Query Builder lets you build five separate types of queries simultaneously:
- Building a SELECT Statement
- Building an INSERT Statement
- Building an UPDATE Statement
- Building a DELETE Statement
- Building a CREATE VIEW Statement
Using Analysis Reports in Space Analyst for Oracle
On the toolbar, click Analysis Report.
- Space Analyst opens the Analysis Report dialog.
In Report File Name and Report Title you can change the location and report title of the report.
In Category, select the types of space problems you would like to investigate. The default option is All.
In Tablespace, select the tablespace you would like to analyze.
Please register for the next DBArtisan Tips and Techniques Demo on Dec 19, 2019 10:30 AM CST at:
After registering, you will receive a confirmation email containing information about joining the webinar.