Oracle

The customer Oracle server enters PL/SQL developer times ora-01033: Oracle initializationg or shutdown in progress error message, the application system cannot connect to the Oracle service. Solve the problem remotely. The process is as follows: 1.

Oracle does not have primary key auto-increment. Unlike MySQL, You need to customize the serial number. How to modify the serial number 1. query the serial number of the latest recordSelect seq from (select * From ch_t_product_music order by seq

When you configure the connection of Oracle10g in myeclipse, the following error occurs: Error while locking Ming database login with the Oracle driver   I have configured all the drivers and paths.   This problem was solved later: Open

If you have not created a table in the system tablespace, you can useSelect * From tabs where tablespace_name! = 'System' Select * From user_tables, unless you create the database in the system tablespace Select ownre, table_nameFrom

If you want to reinstall Oracle and installProgramRunning. Close it first.   Fully uninstall: 1. Stop all Oracle services2. Choose Oracle Installation Products> universal installer to run the Oracle uninstall tool.3. Run the Registry Editor to

The name of the database to be created is dbshop 1: create the required directory export oracle_sid = dbshopmkdir-p $ oracle_base/oradata/$ export-p $ oracle_base/admin/$ oracle_sid/adumpmkdir-p $ oracle_base/admin/$ oracle_sid/bdumpmkdir- p $

String functions: Single-record functions in SQL1. ASCIIReturns the decimal number corresponding to the specified character;SQL> select ASCII ('A') A, ASCII ('A') A, ASCII ('0') zero, ASCII ('') space from dual;A A zero space-------------------------

  1. Problem SourceIn Oracle, you can use dbms_output.put_line to print the prompt information, but it is easy for the buffer to overflow.You can use dbms_output.enable (1000000); To set the buffer size.However, if there is a size, it may overflow

Today, we have a function that requires operations on the clob field. If you encounter several problems during this period, you can solve them. Remember to avoid repeating the same mistakes in the future. Error 1: ORA-22920: the row containing the

  Recently, you may need to connect to a remote ORACLE Server. Although many tools can be connected, such as dbvisualizer and navicat, it is well known that, pl SQL developer is incomparable to any other tool in Oracle operations. In addition,

  "(+)" Can be used in Oracle, and 9i can use left/right/full outer join.Left Outer Join: left Outer JoinSelect E. last_name, E. department_id, D. department_nameFrom employees eLeft Outer Join orders ments dOn (E. department_id = D. department_id );

When two fields in Oracle PL/SQL are determined to be equal or not equal, it often appears that the field values are obviously not equal (one is blank and the other is not empty ), however, true is not obtained when the results are not equal. For

This topic describes common parameters. Audit_file_destParameter type: StringSyntax: audit_file_dest = 'directory'Default Value: ORACLE_HOME/rdbms/AuditParameter category: staticAudit_file_dest defines the path for storing audit files in

Create an Oracle database (taking Oracle10g as an example) There are two ways to create a database: one is to create a database manually using a command line script; the other is to create a database using the Database Configuration Wizard provided

-- You can periodically use the results of DF-h to input an External Log File, and then use Oracle's "External table" to access this "External Log File". For example: -- Step 1: write a script to regularly insert disk information into the log file: [

To execute the exp or imp command, first: 1. Check whether exp.exe and imp.exe files exist in the bin directory of the Oracle installation directory. Otherwise, the command may fail to be executed. 2. Alternatively, you can directly go to the bin

Disk Division Name Size Purpose Drive C (master) 50 GB Install 64-bit Windows 2003 D Disk 184 GB /Oracle Installation Database Software Directory 　 　 /Oracle/oradata data file directory

When I got off work last night, my company's database was suddenly blocked. A Buf table could not extract more than 20 million data and changed the program. The effect was not obvious. Since oracle was restarted once before, I still want to restart

Once all the datafiles were on one disk, resulting in a dramatic increase in Io. Now we divide datafile into three hard disks (due to the large data size, we only consider dividing the data equally without moving the index ). 1. First view the

1. To create a global dblink, you must first confirm that you have the permission to create a dblink: Select * From user_sys_privs where privilege like upper ('% database link % ');   If not, you must use the sysdba role to grant permissions to