User contributions

(newest | oldest) View (newer 250 | older 250) (20 | 50 | 100 | 250 | 500)

• 11:55, 27 November 2020 (diff | hist) . . (+438)‎ . . Networking: some CIDR calculations ‎ (current)
• 20:50, 26 November 2020 (diff | hist) . . (+1,172)‎ . . Networking: some CIDR calculations ‎
• 20:48, 26 November 2020 (diff | hist) . . (+1)‎ . . Networking: some CIDR calculations ‎
• 20:48, 26 November 2020 (diff | hist) . . (+48)‎ . . Networking: some CIDR calculations ‎
• 20:44, 26 November 2020 (diff | hist) . . (+479)‎ . . N Networking: some CIDR calculations ‎ (Created page with "_TOC__ == How to convert a number to a binary number == In the networking IP4 calculations, an IP address is composed of 32 bits, divided into 4 octets: 00000000.00000000.0000...")
• 20:42, 26 November 2020 (diff | hist) . . (+45)‎ . . Oracle Cloud ‎ (current)
• 19:04, 26 November 2020 (diff | hist) . . (+125)‎ . . Oracle Cloud ‎
• 12:51, 26 November 2020 (diff | hist) . . (+100)‎ . . Oracle Cloud ‎
• 13:52, 25 November 2020 (diff | hist) . . (+36)‎ . . Main Page ‎ (current)
• 11:35, 23 November 2020 (diff | hist) . . (+97)‎ . . N Oracle Cloud ‎ (Created page with "[http://rob.lasonder.org/extra/HOL_OCI_CreateCloudAccount.pdf Create a free Cloud Account ]<br />")
• 11:35, 23 November 2020 (diff | hist) . . (+34)‎ . . Oracle Complete Recipes ‎ (current)
• 14:17, 21 November 2020 (diff | hist) . . (+98)‎ . . Oracle Complete Recipes ‎
• 19:30, 9 November 2020 (diff | hist) . . (-3)‎ . . Oracle Complete Recipes ‎
• 19:29, 9 November 2020 (diff | hist) . . (+2)‎ . . Oracle Complete Recipes ‎
• 19:23, 9 November 2020 (diff | hist) . . (+95)‎ . . Oracle Complete Recipes ‎
• 23:21, 2 November 2020 (diff | hist) . . (+11)‎ . . Oracle Complete Recipes ‎
• 23:20, 2 November 2020 (diff | hist) . . (-30)‎ . . Oracle Complete Recipes ‎
• 23:19, 2 November 2020 (diff | hist) . . (0)‎ . . Oracle Complete Recipes ‎
• 23:18, 2 November 2020 (diff | hist) . . (+112)‎ . . Oracle Complete Recipes ‎
• 21:32, 26 October 2020 (diff | hist) . . (+7,139)‎ . . N Real Time Statistics ‎ (Created page with "<pre> Introduction ======= Oracle Database 19c introduces real-time statistics, which extends online statistics gathering to also include conventional DML statements. Statist...") (current)
• 21:31, 26 October 2020 (diff | hist) . . (+31)‎ . . Oracle 19c New Features ‎ (current)
• 19:13, 26 October 2020 (diff | hist) . . (+4,651)‎ . . N High Frequency Automatic Statistics Job ‎ (Created page with "<pre> Introduction ======= • The automatic optimizer statistics collection job which calls DBMS_STATS package runs in predefined maintenance windows and these maintenance wi...") (current)
• 19:12, 26 October 2020 (diff | hist) . . (+50)‎ . . Oracle 19c New Features ‎
• 15:51, 25 October 2020 (diff | hist) . . (+4,082)‎ . . N Create an application container and application ‎ (Created page with "<pre> Introduction ======== Oracle 12.2 introduces the concept of application containers, which act like a mini-root container. They can be used to centralize shared configur...") (current)
• 15:50, 25 October 2020 (diff | hist) . . (+58)‎ . . Oracle Multitenant ‎ (current)
• 10:54, 18 October 2020 (diff | hist) . . (+961)‎ . . Create a refreshable PDB clone and switchover ‎ (current)
• 10:52, 18 October 2020 (diff | hist) . . (+362)‎ . . N Create a refreshable PDB clone and switchover ‎ (Created page with "__TOC__ From Oracle Database 12.2 onward it is possible to refresh the contents of a remotely hot cloned PDB provided it is created as a refreshable PDB and has only ever been...")
• 09:53, 18 October 2020 (diff | hist) . . (+607)‎ . . Create a PDB snapshot carousel ‎ (→‎Example 2 create an automatic PDB snapshot carousel) (current)
• 09:52, 18 October 2020 (diff | hist) . . (+25)‎ . . Create a PDB snapshot carousel ‎ (→‎Introduction)
• 09:51, 18 October 2020 (diff | hist) . . (+558)‎ . . Create a PDB snapshot carousel ‎ (→‎Example 1 create a manual snapshot and create a new PDB from that snapshot)
• 09:50, 18 October 2020 (diff | hist) . . (-1)‎ . . Create a PDB snapshot carousel ‎ (→‎Example 1 create a manual snapshot and create a new PDB from that snapshot)
• 09:49, 18 October 2020 (diff | hist) . . (+1,847)‎ . . N Create a PDB snapshot carousel ‎ (Created page with "__TOC__ == Introduction == This feature allows you to make instant snapshot copies of the Pluggable Database (PDB) and keep them in an external binnacle. A PDB snapshot is an...")
• 09:47, 18 October 2020 (diff | hist) . . (+125)‎ . . N Oracle Multitenant ‎ (Created page with "create a PDB snapshot carousel<br /> create a refreshable PDB clone and switchover<br /> manage a CDB Fleet<br />")
• 09:45, 18 October 2020 (diff | hist) . . (+48)‎ . . Oracle Database ‎ (current)
• 08:21, 8 October 2020 (diff | hist) . . (0)‎ . . Oracle Dictionary ‎ (→‎S) (current)
• 08:21, 8 October 2020 (diff | hist) . . (+1,170)‎ . . Oracle Dictionary ‎ (→‎S)
• 19:19, 6 October 2020 (diff | hist) . . (+1,476)‎ . . GGSCI Utility ‎ (→‎View the GG replication status) (current)
• 19:18, 6 October 2020 (diff | hist) . . (+441)‎ . . GGSCI Utility ‎ (→‎configure supplemental logging)
• 19:03, 6 October 2020 (diff | hist) . . (+24)‎ . . Oracle Utilities ‎ (current)
• 07:31, 6 October 2020 (diff | hist) . . (+886)‎ . . Container Maps ‎ (→‎Synchronize the PDB and add data to the table) (current)
• 07:29, 6 October 2020 (diff | hist) . . (+850)‎ . . Container Maps ‎ (→‎Create an application in the application root that uses the container map)
• 07:27, 6 October 2020 (diff | hist) . . (+6)‎ . . Container Maps ‎ (→‎Create an application in the application root that uses the container map)
• 07:27, 6 October 2020 (diff | hist) . . (+1,120)‎ . . Container Maps ‎ (→‎Create the Container Map)
• 07:25, 6 October 2020 (diff | hist) . . (+926)‎ . . Container Maps ‎ (→‎Create the Application PDBs)
• 07:23, 6 October 2020 (diff | hist) . . (+1,081)‎ . . Container Maps ‎ (→‎Create the application root)
• 07:21, 6 October 2020 (diff | hist) . . (-21)‎ . . Container Maps ‎ (→‎Create the application root and application PDBs)
• 07:21, 6 October 2020 (diff | hist) . . (-53)‎ . . Container Maps ‎ (→‎Introduction)
• 07:20, 6 October 2020 (diff | hist) . . (+1,534)‎ . . N Container Maps ‎ (Created page with "__TOC__ == Introduction == In Oracle Database version 12.1.0.2 Oracle introduced the “CONTAINERS” clause, a very useful clause that can be used to execute queries across...")
• 07:15, 6 October 2020 (diff | hist) . . (+72)‎ . . N Partitioning Enhancements ‎ (Created page with "Converting non partitioned tables to partitioned tables online<br />") (current)
• 07:15, 6 October 2020 (diff | hist) . . (+115)‎ . . N New Features for Datawarehousing and partitioning ‎ (Created page with "Partitioning Enhancements<br /> Partitioning External Tables<br /> Materialized View Enhancements<br />") (current)
• 07:14, 6 October 2020 (diff | hist) . . (0)‎ . . Oracle 12cR2 New Features ‎ (current)
• 07:13, 6 October 2020 (diff | hist) . . (+141)‎ . . N New Features for Utilities and Scheduling ‎ (Created page with "Oracle Datapump Parallel Metadata Management<br /> External Table Access Driver Improvements<br /> In Memory Scheduler Jobs<br />") (current)
• 07:12, 6 October 2020 (diff | hist) . . (+193)‎ . . N New Features for Developers ‎ (Created page with "Cast<br /> Validate_Conversion<br /> Listagg<br /> Approximate query processing<br /> Identifier Length Changes<br /> New Views: DBA_STATEMENTS and DBA_I...") (current)
• 07:10, 6 October 2020 (diff | hist) . . (+4)‎ . . New Features for Compression and Archiving ‎ (current)
• 07:10, 6 October 2020 (diff | hist) . . (+142)‎ . . N New Features for Compression and Archiving ‎ (Created page with "NFS Server in the database<br /> Advanced Index compression enhancements<br /> [[Improvements to Hybrid Columnar Compression (HCC)<br />")
• 07:09, 6 October 2020 (diff | hist) . . (+148)‎ . . N New Features for Performance ‎ (Created page with "Monitoring Index Usage enhancements<br /> Statistics Advisor<br /> In-Memory Advisor enhancements<br /> Per-Process PGA limits<br />") (current)
• 07:07, 6 October 2020 (diff | hist) . . (+207)‎ . . N New Features for Multitenant ‎ (Created page with "Local Undo<br /> PDB Lockdown Profiles<br /> Application Containers<br /> New Features for Creating, Cloning and Moving PDB<br /> Container Maps<br /> Mi...") (current)
• 07:06, 6 October 2020 (diff | hist) . . (+265)‎ . . N New Features for Security ‎ (Created page with "Encryption and Redaction enhancements<br /> Database Vault enhancements<br /> Unified Auditing enhancements<br /> Privilege Analysis enhancements<br /> Separ...") (current)
• 07:04, 6 October 2020 (diff | hist) . . (+72)‎ . . N New Features for Datawarehousing adn partitioning ‎ (Created page with "Converting non partitioned tables to partitioned tables online<br />") (current)
• 07:04, 6 October 2020 (diff | hist) . . (+24)‎ . . New Features for High Availability ‎ (current)
• 07:04, 6 October 2020 (diff | hist) . . (+137)‎ . . N New Features for High Availability ‎ (Created page with "Restart online table definition after failure Cluster resource activity log Flex ASM Disk Group Quota Management Sharding")
• 07:02, 6 October 2020 (diff | hist) . . (+229)‎ . . N New Features for RMAN ‎ (Created page with "Table Recovery Enhancements<br /> Cross-Platform Transport via RMAN<br /> RMAN Duplicate TDE Tablespace<br /> [[Backup and Recovery of Sparse Databases on Exadata]...") (current)
• 07:01, 6 October 2020 (diff | hist) . . (+112)‎ . . Oracle 12cR2 New Features ‎
• 06:59, 6 October 2020 (diff | hist) . . (+136)‎ . . Oracle 12cR2 New Features ‎
• 06:58, 6 October 2020 (diff | hist) . . (-1)‎ . . Oracle 12cR2 New Features ‎
• 06:57, 6 October 2020 (diff | hist) . . (-12)‎ . . High Availability New Features ‎ (current)
• 06:55, 6 October 2020 (diff | hist) . . (+234)‎ . . N High Availability New Features ‎ (Created page with "RESTART ONLINE TABLE DEFINITION AFTER FAILURE<br /> CONVERTING NON PARTITIONED TABLES TO PARTITIONED TABLES ONLINE<br /> CLUSTER RESOURCE ACTIVITY LOG<br /> FLEX...")
• 06:54, 6 October 2020 (diff | hist) . . (+41)‎ . . Oracle 12cR2 New Features ‎
• 06:53, 6 October 2020 (diff | hist) . . (+50)‎ . . Multitenant New Features ‎ (current)
• 06:44, 6 October 2020 (diff | hist) . . (-60)‎ . . Oracle New Features per version ‎ (current)
• 17:37, 4 October 2020 (diff | hist) . . (+41)‎ . . Local Undo ‎ (→‎Local Undo Concept) (current)
• 17:36, 4 October 2020 (diff | hist) . . (+595)‎ . . Local Undo ‎ (→‎Change from shared to local undo)
• 17:35, 4 October 2020 (diff | hist) . . (+270)‎ . . Local Undo ‎
• 17:32, 4 October 2020 (diff | hist) . . (+688)‎ . . N Local Undo ‎ (Created page with "<pre> COLUMN property_name FORMAT A30 COLUMN property_value FORMAT A30 SELECT property_name, property_value FROM database_properties WHERE property_name = 'LOCAL_UNDO_ENAB...")
• 17:31, 4 October 2020 (diff | hist) . . (+21)‎ . . Multitenant New Features ‎
• 10:55, 4 October 2020 (diff | hist) . . (+1,109)‎ . . Application Containers ‎ (→‎Synchronize the changes in the Application Containers) (current)
• 10:52, 4 October 2020 (diff | hist) . . (+1,345)‎ . . Application Containers ‎ (→‎Update the Application)
• 10:51, 4 October 2020 (diff | hist) . . (+985)‎ . . Application Containers ‎ (→‎Create an Application Seed (optional))
• 09:53, 4 October 2020 (diff | hist) . . (+844)‎ . . Application Containers ‎ (→‎Create an application PDB)
• 09:50, 4 October 2020 (diff | hist) . . (+662)‎ . . Application Containers ‎ (→‎Create an application inside the Application Root)
• 09:49, 4 October 2020 (diff | hist) . . (+1,159)‎ . . Application Containers ‎ (→‎Create the Application Root)
• 09:48, 4 October 2020 (diff | hist) . . (+1)‎ . . Application Containers ‎
• 09:47, 4 October 2020 (diff | hist) . . (+599)‎ . . N Application Containers ‎ (Created page with "_TOC__ == Introduction == Oracle 12.2 introduces the concept of application containers, which act like a mini-root container. They can be used to centralize shared configurati...")
• 09:46, 4 October 2020 (diff | hist) . . (+33)‎ . . Multitenant New Features ‎
• 09:34, 4 October 2020 (diff | hist) . . (+49)‎ . . Multitenant New Features ‎
• 09:24, 4 October 2020 (diff | hist) . . (+499)‎ . . Multitentant miscellaneous New Features ‎ (→‎Parallel PDB Creation) (current)
• 09:17, 4 October 2020 (diff | hist) . . (+131)‎ . . Multitentant miscellaneous New Features ‎ (→‎Number of PDB)
• 09:15, 4 October 2020 (diff | hist) . . (+115)‎ . . N Multitentant miscellaneous New Features ‎ (Created page with "__TOC__ == Number of PDB == In 12cR1 you can have up to 255 PDB, in 12cR2 you can have up to 4096 PDB per Container")
• 09:14, 4 October 2020 (diff | hist) . . (+49)‎ . . N Multitenant New Features ‎ (Created page with "Multitentant miscellaneous New Features<br />")
• 09:13, 4 October 2020 (diff | hist) . . (0)‎ . . Oracle 12cR2 New Features ‎
• 13:48, 3 October 2020 (diff | hist) . . (-2)‎ . . Oracle Complete Recipes ‎
• 13:48, 3 October 2020 (diff | hist) . . (-36)‎ . . Oracle Complete Recipes ‎
• 08:56, 25 September 2020 (diff | hist) . . (+555)‎ . . GGSCI Utility ‎ (→‎configure supplemental logging)
• 08:52, 25 September 2020 (diff | hist) . . (+320)‎ . . N GGSCI Utility ‎ (Created page with "__TOC__ == configure supplemental logging == <pre> GGSCI (rob01db01.robdomain as c##/CDB$ROOT) 23> info trandata pdb4.robla.rl_objects GGSCI (rob01db01.robdomain as c##/CD...")
• 08:42, 25 September 2020 (diff | hist) . . (+24)‎ . . Oracle Golden Gate ‎ (current)
• 18:05, 20 September 2020 (diff | hist) . . (0)‎ . . Oracle Complete Recipes ‎
• 18:04, 20 September 2020 (diff | hist) . . (+146)‎ . . Oracle Complete Recipes ‎
• 18:02, 20 September 2020 (diff | hist) . . (-4)‎ . . Oracle Complete Recipes ‎
• 09:25, 11 March 2020 (diff | hist) . . (+2)‎ . . Oracle Dictionary ‎ (→‎L)
• 09:25, 11 March 2020 (diff | hist) . . (+323)‎ . . Oracle Dictionary ‎ (→‎O)
• 20:19, 5 March 2020 (diff | hist) . . (+160)‎ . . Oracle Dictionary ‎ (→‎D)
• 17:18, 5 March 2020 (diff | hist) . . (+527)‎ . . Cursor loop example 1: until end of table ‎ (→‎Example 3: create public synonyms in a loop) (current)
• 12:17, 5 March 2020 (diff | hist) . . (+7)‎ . . Oracle Administration Manage Database Auditing (traditional) ‎ (→‎= Check the user audit trail for the last 100 failed logon attempts in which a wrong password was provided) (current)
• 12:17, 5 March 2020 (diff | hist) . . (+303)‎ . . Oracle Administration Manage Database Auditing (traditional) ‎ (→‎Check the user logon audit trail)
• 10:34, 29 February 2020 (diff | hist) . . (+23)‎ . . Oracle Configuration : Oracle Patches ‎ (→‎Oracle Release Updates (RU) and Release Update Revisions (RUR)) (current)
• 10:33, 29 February 2020 (diff | hist) . . (+272)‎ . . Oracle Configuration : Oracle Patches ‎ (→‎What is a Release Update (RU) ?)
• 10:30, 29 February 2020 (diff | hist) . . (+192)‎ . . Oracle Configuration : Oracle Patches ‎ (→‎Patch Set Updates versus Bundle Patch)
• 10:27, 29 February 2020 (diff | hist) . . (+173)‎ . . Oracle Configuration : Oracle Patches ‎ (→‎Oracle Release Updates (RU) and Release Update Revisions (RUR))
• 10:25, 29 February 2020 (diff | hist) . . (0)‎ . . Oracle Configuration : Oracle Patches ‎
• 10:25, 29 February 2020 (diff | hist) . . (+303)‎ . . Oracle Configuration : Oracle Patches ‎ (→‎Patch Set Updates versus Bundle Patch)
• 10:23, 29 February 2020 (diff | hist) . . (+354)‎ . . Oracle Configuration : Oracle Patches ‎ (→‎Patch Set Updates versus Bundle Patch)
• 10:22, 29 February 2020 (diff | hist) . . (-9)‎ . . Oracle Configuration : Oracle Patches ‎ (→‎Patch Set Updates versus Bundle Patch)
• 10:22, 29 February 2020 (diff | hist) . . (+326)‎ . . N Oracle Configuration : Oracle Patches ‎ (Created page with "__TOC__ == Patch Set Updates versus Bundle Patch == * A Patch Set Update (PSU) contains usually security fixes and regression fixes, i.e. bug fixes. * Whereas a Proactive Bu...")
• 10:21, 29 February 2020 (diff | hist) . . (+48)‎ . . Oracle Administration ‎ (current)
• 18:20, 25 February 2020 (diff | hist) . . (+3)‎ . . NULL values ‎ (current)
• 18:20, 25 February 2020 (diff | hist) . . (+277)‎ . . NULL values ‎ (→‎Null values and indexes)
• 18:19, 25 February 2020 (diff | hist) . . (+2,749)‎ . . N NULL values ‎ (Created page with "__TOC__ == Introduction A NULL value in databases is a systemvalue that takes up one byte ofstorage and indicates that a value isnot present as opposed to a space orzero or an...")
• 18:18, 25 February 2020 (diff | hist) . . (+22)‎ . . Data Modelling ‎ (current)
• 10:35, 25 February 2020 (diff | hist) . . (+1,602)‎ . . N UGA versus PGA ‎ (Created page with "So a connection a made when a client process sends a request to the server process and server process reverts back in establishing the session. But this happens in Dedicated S...") (current)
• 10:35, 25 February 2020 (diff | hist) . . (+25)‎ . . Database Memory Structures ‎ (current)
• 11:28, 24 February 2020 (diff | hist) . . (+218)‎ . . Datapump (export and import database objects) ‎ (→‎Export Database Links of multiple Schemas) (current)
• 11:03, 24 February 2020 (diff | hist) . . (+11)‎ . . Datapump (export and import database objects) ‎ (→‎Export a Schema, but only the tables)
• 11:03, 24 February 2020 (diff | hist) . . (+180)‎ . . Datapump (export and import database objects) ‎ (→‎Export and Import a Schema)
• 21:52, 22 February 2020 (diff | hist) . . (+223)‎ . . N Use large pages ‎ (Created page with "Whether or not the database (SGA) uses large page memory upon startup * FALSE * TRUE : use if possible, otherwise use normal memory * ONLY: use and if not available, do not st...") (current)
• 21:50, 22 February 2020 (diff | hist) . . (+26)‎ . . Oracle Database Parameters ‎ (→‎Parameters) (current)
• 23:12, 21 February 2020 (diff | hist) . . (+199)‎ . . SQL Process Flow ‎ (→‎Step 1 Statement is parsed) (current)
• 23:08, 21 February 2020 (diff | hist) . . (+250)‎ . . SQL Process Flow ‎ (→‎Step 1 Statement is parsed)
• 23:06, 21 February 2020 (diff | hist) . . (+435)‎ . . SQL Process Flow ‎ (→‎Step 1 Statement is parsed)
• 23:03, 21 February 2020 (diff | hist) . . (+18)‎ . . SQL Process Flow ‎ (→‎Step 1 Statement is parsed)
• 23:30, 20 February 2020 (diff | hist) . . (+62)‎ . . SQL Process Flow ‎ (→‎Step 1 Statement is parsed)
• 23:28, 20 February 2020 (diff | hist) . . (+279)‎ . . SQL Process Flow ‎ (→‎Step 1 Statement is parsed)
• 23:24, 20 February 2020 (diff | hist) . . (+489)‎ . . N SQL Process Flow ‎ (Created page with "__TOC__ == Step 1 Statement is parsed == The user issues a statement and the statement is parsed by the database. When an application issues a SQL statement, the application...")
• 23:22, 20 February 2020 (diff | hist) . . (+27)‎ . . Oracle Internals ‎ (current)
• 23:21, 20 February 2020 (diff | hist) . . (+816)‎ . . N Undo versus Redo ‎ (Created page with "Oracle uses UNDO to undo changes and to keep a read consistent image of block. UNDO holds a copy of previous data until the transaction commits and for some time afterwards (d...") (current)
• 23:18, 20 February 2020 (diff | hist) . . (+27)‎ . . Oracle Internals ‎
• 23:16, 20 February 2020 (diff | hist) . . (+31)‎ . . N Database Memory Structures ‎ (Created page with "Database Buffer Cache<br />")
• 23:16, 20 February 2020 (diff | hist) . . (-32)‎ . . Oracle Internals ‎
• 23:15, 20 February 2020 (diff | hist) . . (+37)‎ . . Oracle Internals ‎
• 11:02, 14 February 2020 (diff | hist) . . (+372)‎ . . List database collation ‎ (current)
• 10:56, 14 February 2020 (diff | hist) . . (+104)‎ . . N List database collation ‎ (Created page with "<pre> SELECT CONVERT (varchar(256), SERVERPROPERTY('collation')); SQL_Latin1_General_CP1_CI_AS </pre>")
• 10:55, 14 February 2020 (diff | hist) . . (+58)‎ . . SQLServer Metadata Queries ‎ (current)
• 09:26, 14 February 2020 (diff | hist) . . (+518)‎ . . N SQL and PL/SQL Enhancements ‎ (Created page with "__TOC__ == DML Enhancements == === Row Pattern Matching === Pattern matching provides the ability to recognize patterns in a sequence of rows in a projection, called the row...") (current)
• 09:22, 14 February 2020 (diff | hist) . . (+38)‎ . . Oracle 12c New Features ‎ (current)
• 15:05, 13 February 2020 (diff | hist) . . (-137)‎ . . Private Temporary Tables ‎ (→‎Create a Private Temporay Table) (current)
• 15:04, 13 February 2020 (diff | hist) . . (+296)‎ . . Private Temporary Tables ‎ (→‎Create a Private Temporay Table)
• 15:01, 13 February 2020 (diff | hist) . . (+540)‎ . . Private Temporary Tables ‎ (→‎Introduction)
• 14:58, 13 February 2020 (diff | hist) . . (+697)‎ . . N Private Temporary Tables ‎ (Created page with "__TOC__ == Introduction == Oracle 18c introduced the concept of a private temporary table, a memory-based temporary table that is dropped at the end of the session or transac...")
• 14:57, 13 February 2020 (diff | hist) . . (+60)‎ . . N General Enhancements ‎ (Created page with "Private Temporary Tables<br />") (current)
• 14:57, 13 February 2020 (diff | hist) . . (+30)‎ . . N Oracle 18c New Features ‎ (Created page with "General Enhancements<br />") (current)
• 14:57, 13 February 2020 (diff | hist) . . (+31)‎ . . Oracle 12c New Features ‎
• 09:28, 13 February 2020 (diff | hist) . . (+237)‎ . . Dataguard Enhancements ‎ (→‎Cascaded Redo Transport Destinations) (current)
• 09:26, 13 February 2020 (diff | hist) . . (+1,889)‎ . . N Dataguard Enhancements ‎ (Created page with "__TOC__ == SYSDG Privilege == This new privilege is used to handle Oracle Dataguard administrative duties. This privilege provides only the minimum privilege level required t...")
• 15:57, 11 February 2020 (diff | hist) . . (+1,044)‎ . . Oracle Administration Manage Database Links ‎ (→‎Change a database link password) (current)
• 13:14, 11 February 2020 (diff | hist) . . (+359)‎ . . Datapump (export and import database objects) ‎ (→‎Export Database Links of multiple Schemas)
• 12:08, 11 February 2020 (diff | hist) . . (+159)‎ . . Datapump (export and import database objects) ‎ (→‎Generate SQL File from export file)
• 12:02, 11 February 2020 (diff | hist) . . (+195)‎ . . Datapump (export and import database objects) ‎ (→‎Export Database Links of multiple Schemas)
• 10:38, 11 February 2020 (diff | hist) . . (+116)‎ . . Oracle Administration Manage Database Links ‎ (→‎View current database links)
• 10:36, 11 February 2020 (diff | hist) . . (+4,394)‎ . . N Admin check dblinks.sql ‎ (Created page with "This scripts lists the database links and checks the status of the links. <br /><br /> Sample output: <pre> *** list of available database links *** OWNER DB_LINK...") (current)
• 10:34, 11 February 2020 (diff | hist) . . (+1)‎ . . Oracle Scripts ‎ (current)
• 10:33, 11 February 2020 (diff | hist) . . (+121)‎ . . Oracle Scripts ‎
• 09:17, 11 February 2020 (diff | hist) . . (+758)‎ . . RMAN Miscellaneous New Features ‎ (→‎Sysbackup privilege) (current)
• 09:12, 11 February 2020 (diff | hist) . . (+698)‎ . . N RMAN Miscellaneous New Features ‎ (Created page with "__TOC__ == SQL Commands for the RMAN prompt == You can now execute SQL statements from the RMAN prompt. You no longer need to prefix the SQL Command and you do not need to enc...")
• 09:08, 11 February 2020 (diff | hist) . . (+74)‎ . . RMAN Enhancements ‎ (current)
• 09:07, 11 February 2020 (diff | hist) . . (+33)‎ . . Oracle 12c New Features ‎
• 15:58, 10 February 2020 (diff | hist) . . (+682)‎ . . JSON INFO ‎ (→‎Rules for JSON syntax) (current)
• 15:56, 10 February 2020 (diff | hist) . . (+170)‎ . . JSON INFO ‎ (→‎Features of JSON)
• 15:54, 10 February 2020 (diff | hist) . . (+701)‎ . . JSON INFO ‎ (→‎Why use JSON ?)
• 15:41, 10 February 2020 (diff | hist) . . (+608)‎ . . JSON INFO ‎ (→‎JSON snippet)
• 15:39, 10 February 2020 (diff | hist) . . (+944)‎ . . N JSON INFO ‎ (Created page with "__TOC__ == Introduction == For a while, XML (extensible markup language) was the only choice for open data interchange. But over the years there has been a lot of transformati...")
• 15:35, 10 February 2020 (diff | hist) . . (+282)‎ . . Oracle Dictionary ‎ (→‎O)
• 11:42, 10 February 2020 (diff | hist) . . (+47)‎ . . N RMAN Enhancements ‎ (Created page with "RMAN Restore Table<br />")
• 11:42, 10 February 2020 (diff | hist) . . (+58)‎ . . Oracle 12cR2 New Features ‎
• 11:38, 10 February 2020 (diff | hist) . . (+1,897)‎ . . N SQL Quarantine ‎ (Created page with "__TOC__ == Introduction == This feature is only available for Exadata (Oracle Database Enterprise Edition on Engineered Systems) and DBCS/ExaCS (Oracle Database Exadata Cloud...") (current)
• 11:20, 10 February 2020 (diff | hist) . . (+39)‎ . . N Oracle 19c New Features ‎ (Created page with "SQL Quarantine<br />")
• 11:19, 10 February 2020 (diff | hist) . . (+116)‎ . . Oracle New Features per version ‎
• 11:11, 10 February 2020 (diff | hist) . . (-22)‎ . . Oracle 12c New Features ‎
• 11:10, 10 February 2020 (diff | hist) . . (+126)‎ . . Oracle 12c New Features ‎
• 11:10, 10 February 2020 (diff | hist) . . (-126)‎ . . Oracle Database ‎
• 11:09, 10 February 2020 (diff | hist) . . (+121)‎ . . N Oracle New Features per version ‎ (Created page with "Oracle 12cR1 New Features<br /> Oracle 12cR2 New Features<br />")
• 11:09, 10 February 2020 (diff | hist) . . (-122)‎ . . Oracle Database ‎
• 11:08, 10 February 2020 (diff | hist) . . (+6)‎ . . Oracle Database ‎
• 11:07, 10 February 2020 (diff | hist) . . (+75)‎ . . Oracle Database ‎
• 11:06, 10 February 2020 (diff | hist) . . (+63)‎ . . Oracle 12c New Features ‎
• 10:29, 10 February 2020 (diff | hist) . . (+574)‎ . . Cursor loop example 1: until end of table ‎
• 17:44, 6 February 2020 (diff | hist) . . (+1,122)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Reference) (current)
• 17:29, 6 February 2020 (diff | hist) . . (+842)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Implement the 3rd solution)
• 16:23, 6 February 2020 (diff | hist) . . (+759)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Implement the solution)
• 16:05, 6 February 2020 (diff | hist) . . (+294)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Implement the 3rd solution)
• 16:00, 6 February 2020 (diff | hist) . . (+4,347)‎ . . N Isolation Levels ‎ (Created page with "<pre> ************************************************************* This article is being delivered in Draft form and may contain errors. Please use the MetaLink "Feedback" b...") (current)
• 15:59, 6 February 2020 (diff | hist) . . (+27)‎ . . Oracle Internals ‎
• 15:51, 6 February 2020 (diff | hist) . . (+314)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Explanation)
• 15:49, 6 February 2020 (diff | hist) . . (+215)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Solutions)
• 15:47, 6 February 2020 (diff | hist) . . (+236)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Reproduce the error)
• 15:45, 6 February 2020 (diff | hist) . . (-13)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Reproduce the error)
• 15:45, 6 February 2020 (diff | hist) . . (+346)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Reproduce the error)
• 15:37, 6 February 2020 (diff | hist) . . (+195)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Error Explanation)
• 15:37, 6 February 2020 (diff | hist) . . (+215)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Reproduce the error)
• 15:31, 6 February 2020 (diff | hist) . . (+248)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Reproduce the error)
• 15:23, 6 February 2020 (diff | hist) . . (+83)‎ . . SQLPlus ‎ (→‎Use Bind Variables in SQL Plus) (current)
• 15:21, 6 February 2020 (diff | hist) . . (+166)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Reproduce the error)
• 15:18, 6 February 2020 (diff | hist) . . (+1)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Error Explanation)
• 15:18, 6 February 2020 (diff | hist) . . (+453)‎ . . ORA-08177: can't serialize access for this transaction ‎ (→‎Error Explanation)
• 15:16, 6 February 2020 (diff | hist) . . (+156)‎ . . N ORA-08177: can't serialize access for this transaction ‎ (Created page with "__TOC__ == Reference == My Oracle Support Note : Insert Into Table Fails With ORA-08177 (Doc ID 160593.1) == Error Explanation == == Reproduce the error ==")
• 15:15, 6 February 2020 (diff | hist) . . (+65)‎ . . Oracle Errors and Solutions ‎ (current)
• 10:38, 6 February 2020 (diff | hist) . . (+420)‎ . . N DBMS HM ‎ (Created page with "__TOC__ == Introduction == The Oracle DBA wants to run Health Checks command with Health Monitor upon his database. With Oracle 12c/18c, these checks can be done on a regula...") (current)
• 10:37, 6 February 2020 (diff | hist) . . (+26)‎ . . Oracle Packages ‎ (current)
• 14:02, 1 February 2020 (diff | hist) . . (+392)‎ . . Oracle Dictionary ‎ (→‎C)
• 13:51, 1 February 2020 (diff | hist) . . (+2)‎ . . Oracle Dictionary ‎ (→‎O)
• 13:51, 1 February 2020 (diff | hist) . . (+261)‎ . . Oracle Dictionary ‎ (→‎P)
• 13:50, 1 February 2020 (diff | hist) . . (+733)‎ . . Oracle Dictionary ‎ (→‎I)
• 10:53, 29 January 2020 (diff | hist) . . (+331)‎ . . OUTER JOIN ‎ (current)
• 16:06, 28 January 2020 (diff | hist) . . (+338)‎ . . N DBMS ASSERT ‎ (Created page with "__TOC__ == Introduction == The DBMS_ASSERT package was introduced in Oracle 10g Release 2 and backported to Release 1 in the Oracle October 2005 Critical Patch Update. The pa...") (current)
• 16:05, 28 January 2020 (diff | hist) . . (+34)‎ . . Oracle Packages ‎
• 16:03, 28 January 2020 (diff | hist) . . (+107)‎ . . Oracle Security: SQL Injection ‎ (→‎How to protect against SQL Injection) (current)
• 13:07, 28 January 2020 (diff | hist) . . (+367)‎ . . Rman backup: compression ‎ (→‎Introduction) (current)
• 13:05, 28 January 2020 (diff | hist) . . (+467)‎ . . Rman backup: compression ‎ (→‎How to perform a compressed backup)
• 13:00, 28 January 2020 (diff | hist) . . (+1,238)‎ . . N Rman backup: compression ‎ (Created page with "__TOC__ == Introduction == There are 4 levels of compression for rman: BASIC, LOW, MEDIUM and HIGH. BASIC is free and the others require the "Advanced Compression" license. =...")
• 12:55, 28 January 2020 (diff | hist) . . (+60)‎ . . Oracle Backup & Recovery ‎ (current)
• 12:46, 28 January 2020 (diff | hist) . . (+251)‎ . . Oracle Dictionary ‎ (→‎I)
• 12:46, 28 January 2020 (diff | hist) . . (-250)‎ . . Oracle Dictionary ‎ (→‎D)
• 12:45, 28 January 2020 (diff | hist) . . (+658)‎ . . Oracle Dictionary ‎ (→‎P)
• 12:45, 28 January 2020 (diff | hist) . . (-657)‎ . . Oracle Dictionary ‎ (→‎D)
• 12:45, 28 January 2020 (diff | hist) . . (+94)‎ . . Oracle Dictionary ‎ (→‎R)
• 12:44, 28 January 2020 (diff | hist) . . (+1,560)‎ . . N More copy on write ‎ (Created page with "There are two very different ways to create snapshots: copy-on-write and redirect-on-write. <br /> What all snapshot types have in common is that they are virtual copies not p...") (current)
• 12:42, 28 January 2020 (diff | hist) . . (-1,609)‎ . . Oracle Dictionary ‎ (→‎C)
• 12:41, 28 January 2020 (diff | hist) . . (+1,724)‎ . . Oracle Dictionary ‎ (→‎C)
• 11:56, 28 January 2020 (diff | hist) . . (+260)‎ . . Oracle Security: SQL Injection ‎ (→‎How does SQL Injection take place?)
• 11:55, 28 January 2020 (diff | hist) . . (+157)‎ . . Oracle Security: SQL Injection ‎ (→‎How does SQL Injection take place?)
• 10:56, 28 January 2020 (diff | hist) . . (+456)‎ . . Oracle Security: SQL Injection ‎ (→‎How does SQL Injection take place?)
• 10:46, 28 January 2020 (diff | hist) . . (+491)‎ . . Oracle Security: SQL Injection ‎ (→‎How does SQL Injection take place?)
• 10:01, 28 January 2020 (diff | hist) . . (+1)‎ . . Oracle Security: SQL Injection ‎ (→‎How does SQL Injection take place?)
• 10:00, 28 January 2020 (diff | hist) . . (0)‎ . . Oracle Security: SQL Injection ‎ (→‎How does SQL Injection take place?)
• 10:00, 28 January 2020 (diff | hist) . . (+91)‎ . . Oracle Security: SQL Injection ‎ (→‎How does SQL Injection take place?)
• 09:49, 28 January 2020 (diff | hist) . . (+236)‎ . . Oracle Security: SQL Injection ‎ (→‎How does SQL Injection take place?)
• 09:44, 28 January 2020 (diff | hist) . . (+558)‎ . . N Oracle Security: SQL Injection ‎ (Created page with "__TOC__ == What is SQL Injection ? == SQL injection is a technique to maliciously exploit applications that use client-supplied data in SQL statements. Attackers trick the SQ...")
• 09:42, 28 January 2020 (diff | hist) . . (+72)‎ . . Oracle Administration ‎
• 12:19, 27 January 2020 (diff | hist) . . (+222)‎ . . Oracle Dictionary ‎ (→‎S)
• 16:11, 24 January 2020 (diff | hist) . . (+268)‎ . . Oracle Dictionary ‎ (→‎R)
• 11:32, 24 January 2020 (diff | hist) . . (+29)‎ . . ORA-23622: Operation SYS.DBMS STREAMS ADM.MAINTAIN CHANGE TABLE is in progress. ‎ (→‎Solution II) (current)
• 11:15, 24 January 2020 (diff | hist) . . (+406)‎ . . ORA-23622: Operation SYS.DBMS STREAMS ADM.MAINTAIN CHANGE TABLE is in progress. ‎ (→‎Solution II)
• 11:06, 24 January 2020 (diff | hist) . . (+782)‎ . . ORA-23622: Operation SYS.DBMS STREAMS ADM.MAINTAIN CHANGE TABLE is in progress. ‎ (→‎Solution)
• 10:40, 24 January 2020 (diff | hist) . . (+574)‎ . . N ORA-23622: Operation SYS.DBMS STREAMS ADM.MAINTAIN CHANGE TABLE is in progress. ‎ (Created page with "__TOC__ == Analysis == This error most likely happens when you use Oracle Streams and when an error occurred, for example when you set up a streams configuration and have mad...")
• 10:37, 24 January 2020 (diff | hist) . . (+90)‎ . . Oracle Errors and Solutions ‎
• 17:40, 23 January 2020 (diff | hist) . . (-11)‎ . . Circular references ‎ (current)
• 17:39, 23 January 2020 (diff | hist) . . (+262)‎ . . Circular references ‎
• 13:46, 23 January 2020 (diff | hist) . . (+249)‎ . . N Circular references ‎ (Created page with "__TOC__ A circular reference is a series of references where the last object references the first, resulting in a closed loop. <pre> A => B => C => A </pre> You can prevent c...")
• 13:44, 23 January 2020 (diff | hist) . . (+30)‎ . . Logical Datamodel ‎ (current)
• 11:07, 21 January 2020 (diff | hist) . . (+424)‎ . . RDA ‎ (→‎Step 6 Collect the required information) (current)
• 11:05, 21 January 2020 (diff | hist) . . (+3,969)‎ . . RDA ‎ (→‎Step 6 Collect the required information)
• 10:43, 21 January 2020 (diff | hist) . . (+1,820)‎ . . RDA ‎ (→‎Step 6 Collect the required information)

(newest | oldest) View (newer 250 | older 250) (20 | 50 | 100 | 250 | 500)