Oracle

1. Use1 Create or ReplacePackage refcursor_pkg is2 3 --Author:mr.yang4 --created:5/14/2017 5:13:42 PM5 --Purpose:6Type refcur_t isRefcursor returnSys_product%RowType;7Type Refcur_t1 isRefcursor /*return Sys_product%rowtype*/8 ;9Type Refcur_t2

Cause: Re-installing the operating system, ASM disk retains disk informationProcess steps:[Email protected] ~]# oracleasm listdisksVOL1VOL2VOL3[Email protected] ~]# oracleasm deletedisk VOL1Clearing Disk Header:doneDropping Disk:done[Email protected]

Environment: Redhat 6.5 + Oracle 11G1. Turn off the Linux firewall and disable SELinux2, installation of the required RPM packageYum install-y binutils compat-libcap compat-libstdc gcc gcc-c++ glibc glibc-devel libgcc libstdc libstdc++-devel Libaio

Long time do not touch the database of the bottom details of things, a few days ago, a little guy came to me, not to say compound B*tree Index branch block contains only the pilot column key information, does not contain non-pilot column key value

Client displays "TNS Connection timed out"Run Lsnrctl StatusConnecting to (Description= (address= (protocol=tcp) (host=xxxxxx) (port=1521)))We've got 2 listening processes running.[Email protected] ~]$ Ps-ef | grep TNSRoot 2 0 Mar29? 00:00:00 [Netns]

Oracle 11g installation on Linux Create the required users and groups Vim mk_user.shGROUPADD-G 501 OinstallGROUPADD-G 502 DBAGROUPADD-G 503 OperUseradd-u 501-g oinstall-g Dba,oper OracleSH mk_user.sh Create the desired

Reprinted from: 6112981The Oracle Flashback feature provides more convenience for data to quickly respond to specific data for an object. Several features of the flashback are described earlier, including Flashback Database,flashback drop, Flashback

The name of the Oracle data dictionary consists of a prefix and a suffix, using the _ connection, meaning the following:Dba_: Contains all object information for a DB instanceV$_: Dynamic view of the current instance, including views used by system

[[email protected] ~]# groupadd -g 1300 dba[[email protected] ~]#  groupadd -g 1301 oper[[email protected] ~]# groupadd -g 1000  oinstall [[email protected] ~]# groupadd -g 1200 asmadmin[[email

One, the transition from MySQL to Oracle data types: Number Mysql Tooracle Oracle 1 GEOMETRY Blob Blob 2 GeometryCollection Blob Blob 3

To implement Automatic Memory Management (AMM), you set the following parameters:When you try to start the database instance with these parameter settings, you receive the following error message:SQL > StartupOra-00824:cannot set Sga_target or

Oracle Audit CapabilitiesI. INTRODUCTIONAuditing (Audit) is used to monitor database operations performed by users, and audit records can exist in a data dictionary table (known as Audit records: tables stored in the system tablespace SYS.AUD$ ,

ASC and DESCIndicate ascending and descending, respectivelySELECT * FROM tablename ORDER BY id DESC: According to the ID field in descending order, from big to smallSELECT * FROM tablename ORDER by ID ASC: According to the ID field in ascending

Trunc function can be used to intercept date timeUsage: trunc (field name, precision)Specific examples:-- 按1分钟聚合selecttrunc(stime, ‘MI‘) asstime -- 按1小时聚合selecttrunc(stime, ‘HH‘) asstime -- 按1天聚合selecttrunc(stime, ‘DD‘) asstime -- 示例selecttrunc(cast(

Oracle Wallet use and maintenanceStarting with ORACLE10GR2, using Oracle Wallet to reach any user without a password to log in to the database (non-operating system authentication) is useful for operating with a script to log into a database,

First, Oracle1. Oracle Services1) ORACLEDBCONSOLEORCLOracle Database Console service, ORCL is the instance identity of Oracle, and the default instance is ORCL.2) Oracleoradb11g_home1tnslistenerListener service, the service is only required if the

Explain the oracle Stored Procedure dynamic SQL statement instance and explain the oracle instance Note: In the string''Represents'. For example, 'select ", a from table' Create or replace procedure partition (card_type in VARCHAR2, card_no in

Oracle reported that DBLink synonym calling during Stored Procedure error: PLS-00201: must declare identifier, dblinkpls-00201 A stored procedure needs to be written a few days ago to access the field of the remote database, so a dbLink is created

Redhat7.2 install Oracle11.2.0.4 silently, Redhat7.2 Silent Installation of Oracle11.2.0.4We will install oracle in the/opt/oracle directory, and the subsequent environment variables will be based on this.1. Set host hosts ingVi/etc/hosts[Plain]

Oracle Database migration, table space creation, data table creation, and oracle instancesDatabase migration For database migration, if the source database version is the same as the target database version, Oracle or pl/SQL import is recommended.