Oracle

[Root@localhost server]# rpm-qa binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc-gli Glibc-devel glibc-headers kernel-headers ksh libaio libaio-devel libgcc libgomp Bc-common libstdc++ make Numactl-devel Sysstat

Yesterday, the head was assigned a task, mainly to write a trigger, used in one of the tables in a field update, the same table will also modify another field. I yesterday that tangled ah!! For a long time, the main is not played before the trigger,

Recent Oracle upgrades, from Oracle8 to Oracle9i, have encountered a lot of trouble.The first is the uninstall problem. Because Oracle8 did not use the normal uninstall method, the installation of the oracle9i is difficult. The correct uninstall

Topic: 5. You are performing a blocks media recovery on the TOOLS01.DBF data file in the SALES database using RMAN. Which Two statements are correct in this scenario? (Choose two.) A. You must ensure so the SALES database is mounted or open. B. You

When we use Oracle, if there is a similar character conversion in SQL, there will usually be the above garbled situation, because the Oracle database operating system's character set and the client's character set is not the same, so we need to lang,

Occurrence: Previously because the database query a simple statement is very slow, and then restart the machine resulting in file state may be inconsistent, because the normal shutdown database in conjunction with the verification of files, so that

1. Update (SELECT ..... ) Set column1 = Column2; Update (select Iy.company_name company_name1, CC.COMPANY_NAME_JC company_name2From Income_year_item iy, City_company ccwhere Iy.company_code = Cc.code)Set company_name1 = Company_name2; 2. Only

2008/03/07Skate A variable can be defined in a cursor, and the following is an example of the procedure of my Update column order Create or replacePROCEDURE TEST as--v_id varchar2;--V_num number;--v_x number;I number (10,0): = 1;v_id VARCHAR2 (32);V_

SELECT tablespace_name table Space, To_char (ROUND (bytes/1024, 2), ' 99990.00 ') | | "Actually, To_char (ROUND (free/1024, 2), ' 99990.00 ') | | ' G ' existing, To_char (ROUND (bytes-free)/1024, 2), ' 99990.00 ') | | ' G ' use, To_char (ROUND (10000

In the day-to-day process of dealing with Oracle databases, you may encounter a situation in which a non-SYS or system segment is built in the system tablespace. For a long time, as the volume of data surges, the database will become more and more

I. Preparatory work 1. Effective backupMake a physical backup of Oracle software and databases.2. Check for invalid objects.3. Ensure system's free space is above 50M.4. Shared_pool_size and java_pool_size are at least 150Mb.5. Close the database

Sqlplus/nolog Connect Sys/sys as Sysdba Shutdown normal Startup Mount Appear: ORA-00214: Alter system set control_files=' D:/oracle/oradata/ora10/control02. CTL 'Scope=spfile; ALTER DATABASE Mount Appearance: ALTER DATABASE mount*Line 1th Error:

Oracle namespace Source: http://hi.baidu.com/yinyuman/blog/item/ac65da2a785ae526d42af1cf.html Don't know if you have noticed such a problem in the course of learning, when you create a table named Test. Maybe a few days later, when you do an index

 No output parameters: DeclareJobno number;BeginDbms_job.submit (Jobno,What => ' sp_alert_info; '--sp_dayend as the name of the stored procedure--interval => ' TRUNC (sysdate) + 1 + 17/(24) '--Define time intervalInterval => ' TRUNC (sysdate, '

Declare Cursor C1 is a select FID from t_dev_informationtable; FID T_dev_informationtable.fid%type; Begin Open C1; Loop Fetch C1 into FID; Exit when C1%notfound; Insert into T_dev_maintenancesingles (Fnumber, Fsimplename, FID, Fcreatorid,

After the system upgrade, one of the features is not normal, colleagues want to look at the upgrade before the stored procedures. The first thought is the flashback function, unfortunately, the flashback encountered a ORA-01555 error. SELECT *

1. Specifying scope at set and reset is preceded by a specified SID parameter, otherwise an error occurs. Sql> Show parameter open_cursors; NAME TYPE VALUE------------------------------------ ----------- ------------------------------Open_cursors

The data block db_block_size size of the Oracle database determines the size of the smallest block of data in the database, and you can set your own block size if you do not want to use the default block size when creating the table space. Specific

Time is not to be mistreated. Install the Oracle 11g, need to install the RPM dependency pack, according to the Oracle official website, the need to install the RPM package is certain, but these dependencies may depend on different systems depending

Lack of things Implement the Mount disc. Confirm that the Yum kit is installed[Root@jxk packages]# Rpm-qa YumThe Yum tool is installed if it is shown below.Yum-3.4.3-118.el7.noarch(Basic will have) You can do it again. [Root@jxk ~]#