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
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
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
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
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
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
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
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
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
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/
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 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>
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
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,
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
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
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
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
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