Oracle CREATE TABLE Syntax
Oracle CREATE TABLE Syntax
Oracle V11.1 Description Example >>──CREATE─┬──────────────────┬─TABLE──schema.──table──┬─relational_table─┬─> └─GLOBAL TEMPORARY─┘ ├─object_table─────┤ ...
Oracle Controlling Archive Logging
Oracle Controlling Archive Logging
There are two possible states for archive logging, either off or on. If archive logging is on there are two possible states, either automatic or manual. These are controlled via the initialization par...
How Data Guard Benefited with RMAN 12c New Features
How Data Guard Benefited with RMAN 12c New Features
We know there are 500+ features introduced with Oracle 12c and Multitenant, Indeed there are few new features with RMAN and in this article we are going to see how the 12c RMAN new features are going ...
How to Rock Massive Requirements Gathering
How to Rock Massive Requirements Gathering
Heavy Lifting Most of time, the workload on business analyst is pretty reasonable; however, sometimes a massive amount of requirements must be gathered in a short amount of time. I've helped many comp...
Adding Extended Properties to All Objects (SQL Server Models)
Adding Extended Properties to All Objects (SQL Server Models)
In SQL Server models you can define Extended Properties to various objects manually. In case you wish to add extended properties to multiple objects at once, download a small macro from here. Extract...
How to use the visual database map in Toad for DB2
How to use the visual database map in Toad for DB2
As a Developer or DBA it is important to understand the dependencies and relationship of your database objects. In this short video, Toad for DB2 development manager, Jeff Podlasek, demonstrates how T...
How to use advanced Space Management features of Toad DB2
How to use advanced Space Management features of Toad DB2
As a DBA it is important to closely manage your space usage and understand the benefits that DB2’s architecture provides. This includes keeping data in partitioned tables equally distributed to gain t...
Preserving the data while making a change to a table
Preserving the data while making a change to a table
I was talking to a customer this week about the process of generating a Change Script when they are ready to deploy their changes and they were concerned about the fact that the script generation alwa...
Overview of Toad for SAP Solutions
Overview of Toad for SAP Solutions
This video provides an overview of Toad for SAP Solutions. If you want to try Toad for SAP Solutions, download a 30-day free Trial...
Database Benchmarking Best Practices
Database Benchmarking Best Practices
One of the more common requests that I get from Benchmark Factory users is to provide them with a list of best practices for using Benchmark Factory and for database benchmarking in general. Even for ...
How does Oracle reuse expired and unexpired undo extents?
How does Oracle reuse expired and unexpired undo extents?
A frequent question that I have received from many DBAs is: my undo tablespace is almost full, how can I be sure that the space will be reused? Well, First you have to know that there are two kind of...
Four Questions You Should Ask Before Completing Your Requirements
Four Questions You Should Ask Before Completing Your Requirements
When Push Comes to Shove Gathering requirements seems like a straightforward process, but sometimes it's hard to figure out the relative importance of the requirements. If you're running an agile proj...
- Go to the previous page
- 1
- …
- 123
- 124
- 125
- 126
- 127
- 128
- 129
- …
- 160
- Go to the next page