Oracle

Create a user using Oracle and grant DBA Permissions  Note: 1. If it is enabled in tools such as PL/SQL, directly modify the followingCodeMedium[Italic bold Section]Run 2. Make sure the path exists,For example【D: \ oracle \ oradata \ Oracle9i \]

Database link ORA-01017: invalid username/password     Today I create a database link in Oracle as follows Create database link database_link1Connect to Scott identified by TigerUsing 'pdtt '; When I try

Design tableWhen developing a database application system, the Database Administrator is responsible for planning and creating tablespaces, and planning and creating tables are often completed by application developers. The following factors should

Day: dd number 12 dy abbreviated Fri day spelled out Friday ddspth spelled out, ordinal twelfth month: Mm number 03 mon abbreviated Mar month spelled out March year: YY two digits 98 yyyy four digits 1998 24-hour format time range: 0:00:00-23:59:59 .

In the accident scenario, when I used the database, the power was suddenly cut off. Then the following symptoms appear. Cause Analysis of Shutdown if SQL is executed after Oracle startup Troubleshooting steps: 1. An error occurred while searching

The execution plan in Oracle must be declared. The following is based on Oracle10g and will not be discussed for 8i and earlier versions. I. Execution form Generally, we can execute SQL * Plus. In form, if there are two main differences in the

Overview of basic Oracle Performance Optimization Methods 1) set up reasonable performance optimization goals.2) measure and record the current performance.3) determine the current Oracle performance bottleneck (what is Oracle waiting for and what

Oracle Database hang I. Possible phenomena in database hang 1. The most intuitive thing is that most of your business operations, for example, a query takes a long time, or no results are returned at all. This is different from the simple lock table.

In Oracle, to query the first N records according to specific conditions, use rownum.Select * from EMP where rownum The book also tells you that you cannot use ">" for rownum, which means that if you want to useSelect * from EMP where rownum> 5It is

Oracle's pseudo-column is often translated into pseudo columns, and someone translates it into virtual fields. Data operations often bring unexpected results.Frequently UsedSysdate, policimestamp, rownum, rowid, currval, nextval, uid, user, level,

Http://www.dezai.cn/blog/article.asp? Id = 280   I will package the relevant files here so that you don't have to look for them any more. This problem may easily occur when you are new to EBS. Problem 1: You can use IE browser (IE6 IE7 IE8) to log

Oracle version:10.2.0.1.0 SQL * Plus-version:10.2.0.1.0 This may cause no response to all locally initiated connections to the Oracle Database Server.   Symptom: After the SQL plus command is switched to Oracle, the SQL plus command is not reflected

Query constraint type Select distinct constraint_type fromdba_constraints; Type Code Type description Acts on Level C Check on a table Column O Read only on a view Object P Primary Key

The error message "01652 unable to extend the temp segment through 128 (in the tablespace temp)" is reported when the Oracle stored procedure is executed today ". After running the DF command in Linux, it is found that the space used by the disk is 1

1. install linux I installed Linux 4.4 compiled by Oracle (5 is also available, but it does not support Chinese characters and garbled characters)In addition: Oracle 10g supports liunx versions with redhat-2.1, redhat-3, SuSE-9, SuSE-8 or

3. Set System ParametersModify # vi/etc/sysctl. conf to add the following code: Kernel. Shmall = 2097152Kernel. shmmax = 2147483648(Generally, you can set the maximum shared memory to half the physical memory. If the physical memory is 2 GB, you can

· Spatial index performance 1. Use of spatial indexes There are generally two phases for spatial queries in a spatial database. For Oracle Spatial, a spatial query is divided into two steps, one called primary filter ), the second is secondary

I. Spatial Relationship Calculation The above two chapters are essential for storing spatial data in the database and accelerating the acquisition of spatial data through indexing. From this sentence, we can also see that subsequent chapters are

I. geometric objects · Oracle Spatial 1. sdo_geometry Oracle Spatial defines a series of geometric types and functions in the MDSYS mode to support the storage and use of spatial data. The most common type is sdo_geometry-of course, arcSDE can also

1. Construction of common geometric objects For sdo_geometry, it is best to take several examples to compare it. Fortunately, the Oracle Spatial developer's Guide provides several simple examples, it also comes with good-looking illustrations,