Using autonomous transactions to implement audit functions in Oracle

You can define one or several autonomous transactions in a transaction (outer transaction). Autonomous transactions can be commit independently and do not have an impact on external affairs, and the rollback of the same outer transaction has no

Oracle 9.2.0.8 EXP Export DMP Import report segmentation fault/Segment Fault Resolution

In the 9.2.0.8 RAC Environment, use EXP to dmp any error (per table, exported by user, remote EXP export using TNS method), including export after restarting the database, cannot be imported into other databases (this library, TNS method remote

Oracle Database Jobs Task Queue Example

Jobs is one of the Oracle database objects, timed tasks. Add a task to the task queue by calling the stored procedure dbms_job.submit. View the Dbms_job package, which has two stored procedures: PROCEDURE isubmit (Job in Binary_integer,What in

Security Policy for Oracle database _oracle

The Oracle tutorial you are looking at is the security policy for Oracle databases. ----Oracle is a relational database management system, which has powerful function and excellent performance, and occupies an important position in today's large

Oracle Faq (Configuration of Oracle TAF) _php Basics

If you want to reprint, please specify the source! (Diao greedy first thanked ...) ) Configuration of Oracle Taf TAF is the abbreviation for transparent application failover, the general application of TAF is in the OPS/RAC environment. Since the

Oracle Error 1033 and error ORA-00600 resolution _oracle

This error often occurs in an Oracle database after an illegal shutdown: Exp-00056:oracle Error 1033 appears ora-01033:oracle initialization or shutdown in progress User: Password: This is obviously the database does not have the

Oracle common wait events and processing methods _oracle

Reading notes db file scattered read DB, db file sequential read Db,free buffer waits,log buffer space,log file Switch,log file sync We can view the current waiting events in the system and the information about the resources corresponding to the

Method Analysis of Oracle 10g complete uninstall under Windows _oracle

Oracle Full Uninstall under Windows: Use Oui to unload a database, but there will still be some residue in the registry and file system after uninstalling. These residues not only consume disk space, but also affect Oracle's reinstallation and

An analysis of the not equal number _oracle in Oracle

About the Not equal number in Oracle:In Oracle, <> != ~= ^= is not equal to the meaning of the number. can be used. But it's weird. Yes, I want to take out a product that price is not 180000: (Price is of type number) SELECT ID, name from product

Learn oracle-environment configuration from zero (i)

I. Preparation before the start 1. Launch Oracle Start the Listening service: Oracleorahome90tnslistener Start Instance service: Oracleserviceorac 2.Oracle System User Oracle three major system users By default: System/welcome Super User: Sys/

How to clone a database using Rman in Oracle

Source Library rhel4.5:192.168.137.199 Global_name=wending. LK oracle_sid=wending Clone Library rhel4.5:192.168.137.200 GLOBAL_NAME=STRM. LK ORACLE_SID=STRM 1. Full Backup Source Library $ Sqlplus '/as sysdba ' Note the SCN before the backup,

Oracle's Single-line functions: Character functions

Character function 1.ASCII (x) and Chr (x) ASCII (x): Returns the ASCII code for the character X Chr (x): Returns a character with an ASCII code of X 2.concat (X,y) Used to add Y to X after, with | | function as 3.initcap (x) Converts the

Oracle DG Physical Standby environment setup

Oracle Data Guard, logical standby and physical standby. Here are the steps to build a physical standby environment. First, enable Force Logging Set the primary database to force logging mode. Use the following statement: View Status: Sql>

Oracle DataGuard 11g Dual-machine experiment

| operating System | Release 6.7 | Release 6.7 || host name | STUAAPP01 | STUAAPP02 || ip|192.168.20.234|192.168.20.235 |Database software version |oracle 11.2.0.4.0|oracle 11.2.0.4.0 || oracle_base|/u01/app/oracle/|/u01/app/oracle/|| oracle_home|

"Go" Oracle Architecture

The interviewer asked me about Oracle's architecture a few days ago, and let me draw it on a blank sheet of paper. Looking back at that time answer is also good, most of the content is described, hehe, just saw an article on the internet to explain

Oracle Login Error ora-28000:the account is locked

Ora-28000:the account is lockedThe first step: using PL/SQL, the login name is system, the database name is not changed, select the type of time to change the normal to SYSDBA;The second step: select Myjob, view users;Step three: Select System,

Oracle 11g RAC installation grid error resolution

1. The shared disk cannot be found on the RAC2 node using oracleasm[Email protected] ~]# oracleasm scandisksReloading Disk Partitions:doneCleaning any stale ASM disks ...Scanning system for ASM disks ...[Email protected] ~]#Workaround:The partition

Oracle Custom Job name, Job scheduler

begin--create_schedule dbms_scheduler.create_schedule (schedule_name='S_change_send_dates_statue', start_date=sysdate, Repeat_interval='freq=minutely; Interval=1', Comments='Customs side received enterprise data Change status schedule'); End

Go How does I use the variables in Oracle SQL Developer?

This article transferred from: Http://stackoverflow.com/questions/5653423/how-do-i-use-variables-in-oracle-sql-developerBelow is a example of using variables in SQL Server 2000.DECLARE @EmpIDVar INTSET @EmpIDVar = 1234SELECT *FROM EmployeesWHERE

Oracle 11g Learning 3--table Space Operations

I. Overview of table SpacesThe tablespace is the largest logical storage structure in Oracle and corresponds to the data files in the operating system;Basic tablespace: A permanent tablespace used by the user to store the user's persistent

Total Pages: 2147 1 .... 150 151 152 153 154 .... 2147 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.