Oracle

How to connect to Oracle remotely with Plsql on a computer that does not have Oracle installedDownload Instantclient, my is WIN7, download is Instantclient-basiclite-nt-12.1.0.1.0.zipUnzip to a fixed directory such as C:\instantclient_plsqlCreate a

Use of packages in OracleThe use of packages is primarily to implement the modularity of the program, the package can be related to the stored procedures, functions, variables, constants and cursors and other PL/SQL programs together, in this way

Recently encountered a case:Status: HP-UX operating system, Oracle 10.2.0.4 RAC, MCSG mode, 2 OCR and 3 voting disk each correspond to one LV in the same concurrent volume groupPurpose: To mirror shared storage, the technology used is HP's own HP

First, background:The specific scenario is that the database is not an ordinary OLTP system, more like an OLAP system, the data update frequency is very low, operating in the Noarchivelog mode, real-time requirements are low, but only one copy of

Today, the customer gave me a table from the ORACLE11G database to export a data file to me, the file suffix is dmp file, I put DMP file into our business database error, and later on-line check is due to the Oracle database version inconsistency

@echo off Echo ================================================ Echo automatic backup script for Oracle database in Windows echo 1. Use the current date to name the backup file. Echo 2. Automatically delete backups up to 30 days ago. echo ===========

Oracle Database user manages Oracle permissions settingsFirst, the Classification of rights:System permissions: The system specifies the user's permission to use the database. (System permissions are for users). Entity permissions: A permission user'

Oracle SQLLDR Use (fast import, but weak handling of the data itself)Blog Category: Db. Oracle Oraclesql Sqlload.cmdSQL code Pause Sqlldr user/[email protected] control.ctl skip=1 rows=2000 bindsize=8192000 Pause

Crontab-eNo crontab for root-using an empty oneCrontab:installing New Crontab"/tmp/crontab. Jkmaak ": 1:bad minuteErrors in crontab file, can ' t install.Want to retry the same edit?Enter Y or NWant to retry the same edit? YCrontab:installing New

Add Standby LogMain Library parameter file:crm.__db_cache_size=8254390272crm.__java_pool_size=33554432crm.__large_pool_size=33554432Crm.__oracle_base= '/u01/app/oracle ' #ORACLE_BASE set from environmentcrm.__pga_aggregate_target=3288334336crm.__sga_

High-performance PL/SQLAssuming the code meets functional requirements, PL/SQL code needs to meet 3 conditions to become efficient:1. Performance: The operating time is within an acceptable range.2. Impact: It does not disrupt (or weaken in some

Get all the hours in a whileSELECT to_date (' 2013-07-01 ', ' yyyy-mm-dd hh24 ') + (ROWNUM-1)/sdate from dualCONNECT by ROWNUM Get all the days in a whileSELECT to_date (' 2013-07-01 ', ' yyyy-mm-dd ') + ROWNUM-1 sdate from dualCONNECT by ROWNUM Get

There has been no contact with Oracle database before, and recently the company has a project that needs to be used, so start tossing Oracle. Just started to go a lot of detours, in order to help more and I just started to contact Oracle's small

Path-third-party Oracle service providerValueThe main business of traditional third-party Oracle service providers exist, such as system migration, upgrade, fault handling, performance optimization and some very basic business requirements. But this

OracleRAC rebuilding OCR and Votedisk   Environment:OS: redhat 5.8DB: Oracle 10.2.0.5 raw device We need to develop the habit of backing up ocr and votedisk frequently. However, ocr and votedisk can be rebuilt without backup. It is like a control

[ORACLE] Methods for adding and deleting disk members in an ASM disk Step 1: Disable the database shutdown immediate Step 2: Check the mounting diskgroup status of the dg. SQL> show parameter diskgroup Alter diskgroup dgdata mount; Step 3: view the

Automatic backup script for Oracle databases in Windows @ Echo off echo ============================================ ================= echo in Windows environment, the Oracle database's automatic backup script echo 1. use the current date to name

Log File mode in oracle There are two log modes in oracle Database: Non-archive log mode and archive log mode. In the oracle database system, to prevent the contents of log files from being overwritten during cyclic use, the oracle System Copy and

Several data loading methods for oracle11G Data Loading Data Loading: • SQL * LOADER • External table • Import/Export SQL * LOADER:SQL * LOADER is an ORACLE tool that can load data from external data files to databases. The command for running

[ORACLE] processing of oracle time objects 1.1 Use of oracle date objects (1) Create A date Field For example, Create table foo_7 (d1 date ); (2) Use the to_date function to insert a date object. To_date ('string', 'string' format ') For