Oracle

Exp/imp three modes-full, user, and table ORACLE databases have two backup methods. The first type is physical backup. This method enables complete database recovery, but the database must run in the recovery mode (the business database runs in the

How to configure Oracle listener. ora file Oracle listener is an important database server component and plays an important role in the entire Oracle architecture. Listener Lisener FunctionFrom the current Oracle version, Listener is mainly

Oracle materialized view generally uses a materialized view because there are a large number of query summaries and the speed is taken into account. I simply sorted out what I used. First look at the simple creation statement: create materialized

SP2-1503: Unable to initialize Oracle call interface (same fashion 10g and 11g) solution 1. The error SP2-1503: Unable to initialize Oracle call interfaceSP2-0152: ORACLE may not be functioning properly 2 is reported when sqlplus/as sysdba is

Oracle journey (1) scheduled task settings use pl/SQL to log on to the oracle database. In procedures, create a scheduled task, manipulate the logon table, and insert daily data into the temporary table. The SQL statements for scheduled tasks are as

Oracle journey (ii) SQL statement query settings such as t_chmo_order_opera p, business table t_chmo_teruser u, user table t_chmo_province, Province table t_chmo_opera_price r price list ----- value-added business details select p. oo_source_num as

Listen for configuration independent of the database server, solve ORA-12520 and ORA-12545 errors 1. Environment: 1. linux host ocm (192.168.217.130) as Database sys @ OCM> select * from v $ version; BANNER monitoring Oracle Database 11g Enterprise

Example of a simple oracle stored procedure -- create procedure without a parameter: drop procedure proc_testcreate or replace procedure proc_testistestvalue varchar2 (40); beginselect user_name into testvalue from user_info where user_id = 1001;

Introduction to Oracle 11G Virtual Column [html] Oracle 11G Virtual Column Oracle 11G introduces Virtual columns in the table, Virtual Column is an expression, which is calculated at runtime, the virtual column value cannot be updated because it is

When Will instance recovery be generated after in-depth analysis of instance recovery? When your database server suffers an abnormal power failure, instance recovery will occur when you restart the database. Instance recovery is automatically

[Oracle] database security-audit Oracle audit is an afterthought task. After a database security problem occurs, you can trace the source of the problem to locate and discover it. Oracle audit mainly includes the following three parts: Trigger-based

The size limit of a single data file in the oracle database. For example, if you see an error, you may think that the size of the data file conflicts with the restriction rules, because you have learned some related knowledge before, I was a little

Oracle Tablespace Transportation premise: the user must have SYSDBA system permissions for Tablespace transmission. The moved Tablespace is a self-contained Tablespace and should not depend on the existence of objects of external Tablespace objects.

[Oracle]-[sort aggregate]-count and index Oracle10g: create table t_count as select * from dba_objects; create index t_count_ I on t_count (object_id): select count (*) from t_count; select count (object_id) from t_count; select count (object_name)

On commit preserve rows define declarative global temporary tables each session has its own unique temporary table description. When the session ends, both the table row and the description of the temporary table are deleted. The following options

Oracle Delete foreign key constraint-Disable constraint-enable constraint execute the statements generated by the following SQL statements to delete all foreign key constraints SQL code select 'alter table' | table_name | 'drop constraint' | |

How does E-business suite manually cancel the request [python] SQL> UPDATE fnd_concurrent_requests SET phase_code = 'C' in the concurrency manager ', status_code = 'X' WHERE request_id = ''; commit; sometimes, requests cannot be canceled on the form

PLSQL Developer connects to Oracle11g 64-bit database configuration details recently changed to a 64-bit computer, so oracle database also changed to 64-bit, but the problem also arises, since plsql developer does not have a 64-bit version, it

Encountered ORA-01078, LRM-00109, ORA-27046 SPFILE file File Corruption solved today when starting the database encountered $ Sqlplus/as sysdbaSQL * Plus: Release 10.2.0.4.0-Production on Tue Jul 16 21:28:03 2013 Copyright (c) 1982,200 7, Oracle.

Load: oracle tool: sqlldr consists of four steps: creating a table with a source data file (test.txt) and creating a control file (test. ctl), create a bat file (or shell file) focuses on: If the table has the number type, or the date data type can