Friday, March 31, 2017

How to import only users over a network link

›
Use the following parameter file to import only the user definitions from your source database to your test database: Remember that the d...
Wednesday, March 29, 2017

How to create a startup-trigger

›
In this example, I needed to write a simple trigger that opens the wallet upon startup of the instance: create or replace trigger open_w...

How to solve ORA-01031: insufficient privileges when creating a materialized view

›
At first, I got the following error from the Oracle server when exeuting the "CREATE MATERIALIZED VIEW" script: where tab2.yea...
3 comments:
Tuesday, March 28, 2017

How to redefine a table that is created with an identity column

›
You have the following non-partitioned table defined: CREATE TABLE MYTABLE ( ENTRY_SEQ_NUM NUMBER Generated as Identity ( START W...
3 comments:
Thursday, March 16, 2017

The syntax for enabling and disabling a constraint

›
To enable a constraint: ALTER TABLE mytable ENABLE CONSTRAINT mytable_c1; or, if you wish to enable the constraint and validate its correc...
Wednesday, March 15, 2017

How to add a check constraint to a table using ALTER TABLE

›
The following statement adds a check constraint to the table and allows Oracle to give it a system generated name: ALTER TABLE MYTABLE ADD ...

How to find wait information about a session

›
Yesterday, I had started a script with two long-running queries before I my shift ended, and it was finished when I got back, as expected. ...