Oracle

PL/SQL exceptions and control statements in PL/SQL [/color] [color = orange] SQL> set serveroutput on SQL> remark control statement SQL> remark Exception Handling www.2cto.com SQL> REMARK ........................................ ..................

Start and Stop Oracle Database in SQLPLUS 1. Start and Stop database 1. Start www.2cto.com SQL> connect system/manager as sysdba; SQL> startup open database instance name. Another method is as follows: install the database and run the alter database

It makes PL/SQL easier to use. all SQL statement characters are capitalized. The core of the information system is the database. When a system goes wrong, the first query is the SQL statement, how to quickly find the SQL statement in the vast log is

Two ways to create an Oracle database: 1. run Oracle Database Configuration Assistant to create a Configuration or delete a Database (you can also enter dbca in the command line); 2. create a database using the command line: 1. you can run Oracle

Database Link is the most used in Distributed Systems. Today, a problem occurs when Database links are used:When updating a table in a remote database, the following error occurs: for example, when executing such a statement: update

Undo tablespace role and ora-01555 below we through DML operations, from a simple to a deep interpretation of the role of undo tablespace and the generation of ora-01555 errors: 1, when we issue DML statements, update t set col = 'B' where col = 'a';

ORA-01157 error "cannot identify/lock data file" solve sqlplus access to the database as an administrator, error occurs at startup, as follows:> sqlplus "/as sysdba" SQL> startup ...... ORA-01157: cannot identify/lock data file 8-see DBWR trace

Reference for rman backup policy formulationI. Before formulating the rman backup policy, redo logs should be evaluated. This article follows the suggestions in the official documentation: Recommended: Oracle recommends that you multiplex the online

Oracle a Chinese character occupies several bytes. Oracle a Chinese character occupies several bytes. It depends on the character set encoding in Oracle.View the oracle server Character Set select userenv ('language') from dual. If the following is

Oracle Custom Field Type target: define a method for writing data types Use a custom TYPE to CREATE a table for a field Add a data method for querying data other define a TYPE of SQL code CREATE OR REPLACE TYPE PropertyValue AS OBJECT (number_value

Oracle High Water level line I. oracle High Water level line I. What is a High Water Mark )? All the oracle segments (segments here, for ease of understanding, we recommend that you use segment as a synonym for the table) have an upper limit to

Learn SQL statement responsibilities, users, request groups, and concurrent programs. select frv. DESCRIPTION from fnd_responsibility fr, ----------- responsibility fnd_concurrent_programs fcp, ----- concurrent program limit frv, ------------

Oracle common syntax and statement collections 1. case when example select task_id taskId, start_time startTime, end_time endTime, status, plan_type planType, is_manual isManual, is_pilotCal isPilotCal, scheduling_code schedulingCode from

Why does the GoldenGate replicat process display running without applying any records? Sometimes, we will find that the status of the replicat process shows running, but the report shows that no records are updated. There are four main reasons for

Some minor knowledge in Oracle Applications 1. how Does oracle view the SQL statement running in the background select. program, B. spid, c. SQL _text from v $ session a, v $ process B, v $ sqlarea c where. paddr = B. addr and. SQL _hash_value = c.

Oracle restores the index/constraint of the deleted tableI recently visited AskTom and asked a good question:Q: How can I restore the index and constraints of the deleted table through the Flashback Technology?Let's take a look at Tom's answer:A: In

Oracle SqlPlus statement bit by bit records start Oracle listening: lsnrctl start view Oracle listening status: lsnrctl status start OracleServiceORCL service: net start OracleServiceORCL view the service name of the Oracle database to be connected,

RMAN delete expired & delete obsolete read the official documentation for explanation: delete exipired [plain] If you run CROSSCHECK, and if RMAN cannot locate the files, then it updates their records in the RMAN repository to EXPIRED status. you

RMAN Compressed Backupset: [plain] There is some CPU overhead associated with compressing backup sets. if the database being backed up is running at or near its maximum load, you may find the overhead from using as compressed backupset unacceptable.

ORA-27102: out of memory Linux-X86_64 solution 1. startup Linux oracle reported the following Error ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on device 2. check the alter log and report: Checkpoint not complete Current log #3