Oracle

For large systems such as clustering and distributed, time and its synchronization are very important issues. The study of Redhat Linux and JRE (including Oracle JRE,IBM JRE) is summarized below. 1, the view of the time The usual time can be

SceneThe database throws the following error at startup Ora-00604:error occurred at recursive SQL level 1Ora-00607:internal error occurred while making a change to a data blockOra-00600:internal error code, arguments: [4194], [7], [7], [], [], [], [

Oracle table space Export, user deletion, table space deletion, user new, table space new, data import shellExecute the script with a non-Oracle userParameter name$1:base the user name of the table space$: User name for synchronization table

Oracle Listener Boot 1067 error handling In a web development exercise, when you use an Oracle database and then start the Oracle service, you start the Oracleoradb10g_home1tnslistener service with a 1067 error or start, but the display closes after

Oracle Oracle Product Services and Technology level introduction Many friends ask the genuine Oracle database products and pirated products are mainly different, in fact, from the product technology itself, the difference is not small, can

In the actual work we often encounter some Oracle database performance is low, of course, the reasons for the low performance of Oracle database is various, we can through some correct design and diagnosis to try to avoid some Oracle database

Original statement with no double quotes on the surface:INSERT into Xm_ftp_lvl_mgr_hr VALUES (' 191 ', ' 457 ', ' Zhang A810 ', ' 080072 ', ' 1 ', ' null ', ' null ', ' null ', ' 1 ', ' null ', ' system administrator ', ' 2018-06-21-11:47:59 ', '

Problem Description:Oracle uses PL/SQL developer to export data to CSV format, VARCHAR2 Type field if the value (for example, 3307830000004059) is too long, the CSV file is represented in scientific notation, even if the column is selected, click

1.1UseOradebug- -Start taskOradebug Setmypid-- Set the name of the dump file to indicateAlter session Set Tracefile_identifier=undo-- view dump fileSql> Oradebug Tracefile_name;C:\opt\oracle\product\10.2.0\admin\rundb\udump\rundb_ora_6660_pra1.trc--

Different character sets cause problem resolution of date type displayAlter session set nls_date_language= ' AMERICAN ';Unlock Scott AccountAlter user Scott identified by Tiger account unlock;Distinct to remove duplicate rowsThe format of the basic

Management of 1.Oracle Tables Naming conventions for table and column names: Must start with a letter; Length cannot exceed 30 characters; Cannot use Oracle's reserved words; Use only the following characters: A-Z, A-Z, 0-9,

Install Oracle 11G Single-instance database on Linux under VM virtual machine1. Environment and pre-installation planning: virtual machines and OS as followsEnvironment: VMware wordstation Ace Edition 6.0.2Operating system:

Author: Jason priceAddress: http://www.oracle.com/technology/global/cn/pub/articles/price_dbtrans_dotnet.html Understand the basics of writing database transactions in Visual Basic. NET and C. ExampleCode:

Differences between Oracle SYS and system users, sysdba and sysoper system permissions, and sysdba and DBA roles) Differences between sys and system users1) The most important difference is that the importance of stored data is

 1. Alert Log description   In the Oracle 11.2.0.2 database, a large number of alert logs are found as follows:   Fatal Ni connect error 12537, connectingto: (Local = No)   Version Information: TNS For HPUX: Version 11.2.0.2.0-Production Oracle

  In Oracle Linux 5, we can use ORACLE validated configuration to accelerate the deployment of the Oracle environment. For more information about validated deployments, see: Oraclevalidated configurations installation

Oracle9i was released on Oracle Open World in October 2000, introducing many new features for Oracle databases, application servers, and development tools. Oracle9i is the industry's first complete and simple software infrastructure for a new

Reprinted: http://www.cnblogs.com/xiaoluo501395377/archive/2013/04/07/3003278.html I have modified some mysql commands to start the cloud To develop j2ee on Linux, you must first build a j2ee development environment, including jdk, tomcat, and

Windows 7 64-bit Oracle SQL Developer tool, win7developer In the process of using Oracle SQL, a lot of reference materials, counseling institutions, and various books are mostly explained using PL/SQL, but the problem is that PL/SQL does not provide

Some time ago with a set of 11203 rac adg on EXADATA Machine environment, in the ADG standby side node2 through dblink query prompt ora-1089 error, but in node1 query normal, the recover process of DG is on node1. then it is confirmed that it is a