Showing posts with label DDL. Show all posts
Showing posts with label DDL. Show all posts
Thursday, March 10, 2022

How to use dbms_metadata to generate DDL for a Unified Auditing Policy

›
SQL> set long 5000 SQL> select DBMS_METADATA.GET_DDL('AUDIT_POLICY','ORA_LOGON_FAILURES') from dual; DBMS_METADATA...
Thursday, June 17, 2021

How to generate dbms_application_info settings together with DDL in a sql script

›
Many DBAs forget to incoporate usage of dbms_application_info into their own scipts. This is particulary important if you start long-runni...
Tuesday, July 14, 2020

Identity columns in Oracle 12c

›
The identity column introduced in Oracle 12c can be used in the different manners, according to your needs. Here are some basic examples: ...
Tuesday, December 20, 2016

Will interrupting a "split partition"-command cause any harm to your database?

›
Will interrupting a "alter table split partition"-command cause any harm to your database? No, it will not. It is safe to kill t...
Friday, October 30, 2015

Syntax for setting the default undo tablespace for the instance

›
ALTER SYSTEM SET undo_tablespace='APPS_UNDOTS1' SCOPE=BOTH;
Thursday, April 9, 2015

How to use dbms_metadata to generate DDL for profiles

›
An easy way to migrate your profiles from a source database to a target database during migration is to use the dbms_metadata package. To ...
Friday, October 17, 2014

Script example: create database

›
CREATE DATABASE "mydb" MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE...
Wednesday, March 26, 2014

How to use the dbms_metadata package to generate DDL for a user

›
-- Arg #1 schema name -- Arg #2 DB Directory whenever sqlerror exit 1 whenever oserror exit 2 set long 100000 verify off feedback off accep...

How to use the dbms_metadata package to generate DDL for table

›
accept table_name prompt 'Table name: ' accept owner prompt 'Table owner: ' set long 90000 set longchunksize 300 set pagesi...
Saturday, October 19, 2013

How to set a timeout for DDL operations in oracle11g - to avoid "resource busy" error

›
ALTER SESSION SET DDL_LOCK_TIMEOUT = 10; when a DDL statement in the session does not get the exclusive lock, it will not error out. Inst...

The reason for "ORA-12052: cannot fast refresh materialized view" during Online Redefinition

›
Online Redefinition of an object relies on Material View (MView) logs to keep track of all data changes in the table under redefinition *whi...