November 21, 2023

LOADING DATA INTO ORACLE TABLES ( sp_get_set_and_load ) This doc details the procedure evolved to automate the process of loading the data into Oracle database using SQL*Loader. The functionality of the procedure: (1) Go to the destination directory and get the list of the .dat files. (2) Verify whether the file name (without) extension tallies …

LOADING DATA INTO ORACLE TABLES Read More »

INSTALLING ORACLE 11.2.0.4 ON X86 64 BIT LINUX RHEL – REQUIREMENTS? (FROM AND BY ORACLE) APPLIES TO: Oracle Database – Standard Edition – Version 11.2.0.4 to 11.2.0.4 [Release 11.2]Oracle Database – Enterprise Edition – Version 11.2.0.4 to 11.2.0.4 [Release 11.2]Linux x86-64 PURPOSEThis note explains the requirements that need to be met for a successful installation …

INSTALLING ORACLE 11.2.0.4 ON X86 64 BIT LINUX RHEL – REQUIREMENTS‏ (FROM AND BY ORACLE) Read More »

INSTALLATION OF ORACLE DATABASE Oracle Installation and Database Development On UNIX and Windows Platforms – A comparison UNIX Windows NT/2000/XP On UNIX, several files and scripts in different directories are used to start an instance automatically. Other scripts are run on computer shutdown, allowing applications such as Oracle to shut down cleanly For automatic startup …

INSTALLATION OF ORACLE DATABASE Read More »

HOW TO SPLIT A SINGLE PARTITION INTO MULTIPLE PARTITIONS IN 12C  APPLIES TO: Oracle Database – Enterprise Edition – Version 12.1.0.1 and later – Information in this document applies to any platform. Oracle 12C supports splitting a partition into more than 2 partitions. You can redistribute the contents of one table partition into multiple partitions …

HOW TO SPLIT A SINGLE PARTITION INTO MULTIPLE PARTITIONS IN 12C Read More »

HOW TO REMOVE STREAM 01. remove streams EXEC DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION(); 02. drop queue tables select OWNER,NAME,QUEUE_TABLE from dba_queues where owner=”; then exec DBMS_STREAMS_ADM.REMOVE_QUEUE(”); 03 drop supplemental logging select ‘alter table ‘||owner||’.’||table_name||’ drop supplemental log data (all) columns;’ from DBA_LOG_GROUPS where owner=”; execuatable SQL statements will be the output. run them. You are done.

HOW ORACLE WORKS The following example illustrates an Oracle configuration where the user and associated server process are on separate machines (connected via a network). An instance is currently running on the computer that is executing Oracle (often called the host or database server). A computer running an application (a local machine or client workstation) …

HOW ORACLE WORKS Read More »

DBNEWID D:oracleOra92bin>nid help=yes DBNEWID: Release 9.2.0.6.0 – ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved. Keyword Description (Default) TARGET Username/Password (NONE) DBNAME New database name (NONE) LOGFILE Output Log (NONE) REVERT Revert failed change NO SETNAME Set a new database name only NO APPEND Append to output log NO HELP Displays these messages NO …

DBNEWID Read More »

DATABASE TESTING AND PATCH QUERYING Srinivas Maddali Database Testing The following sections describe database testing features. Mask-At Source or Mask During Subset To mask confidential data for non-production use, enterprises needed to make a copy of the production database and then mask the data before sharing it with non-production users such as testers or developers. …

DATABASE TESTING AND PATCH QUERYING Read More »

ORACLE 12C DATABASE AUTHENTICATION METHODS FOR THE ADMINISTRATORS The purpose of differentiating these authentication methods was to differentiate the roles and also secure the database and the docs read “Database Administrators can authenticate database administrators through the data dictionary, (using an account password) like other users. Keep in mind that database passwords are case-sensitive.” Database …

ORACLE 12C DATABASE AUTHENTICATION METHODS FOR THE ADMINISTRATORS Read More »