oracle database 11g sql fundamentals

enter a short password that you normally use, and you don't have to add numbers to the 8-bit size that Oracle recommends. Oh. Note: Sys/system, also modify the new password, confirm the password. 15. Similarly, passwords that do not conform to the rules are prompted. Don't worry about it, continue Y. 16. The installation is successful and complete. It's simple, hehe. three. After installation, access to the test can be done by starting, "

I recently looked at a blog and found that Oracle 11g provided the new feature of user rename. In a 10g environment, if you want to rename a user, you should first create a new user and authorize it, import all objects under the original user and delete the old user! Next we will introduce this new feature in the 11g rac environment! 1. Create a test user xxx and

Two test samples were made in the art of simulating Oracle performance diagnostics. The book says not to bear relies_on. Cache (Result_cache relies_on (test1,test2)). The test proved incorrect, and the function F1 () did not use relies_on, but the changes on the table affected the function. C:\Documents and Settings\guogang>sqlplus Gg_test/[email Protected]_ggSql*plus:release 10.2.0.1.0-production on Monday August 4 19:46:44 2014Copyright (c) 1982, 20

The ORA-00845 is prompted when the database is started: MEMORY_TARGETnotsupportedonthissystem (the parameter MEMORY_TARGE for Automatic Memory Management added in oracle11g The ORA-00845 is prompted when you start the database: MEMORY_TARGET not supported on this system (the parameter MEMORY_TARGE for Automatic Memory Management added in oracle

Oracle 11g how to clear the execution plan of an SQL statement in the share pool, 11 gpool In the past, if the execution plan was slow due to binding snoop on a 10 Gb database, you wanted to clear the execution plan of an SQL statement and make it hard to parse it, after sea

Label:How the database uses tables when storing data: Columns are called fields in the database Rows are called records in the database Data type: Character data type: char, varchar, etc. Date Time Data: datetime, etc. Numeric type: int, float, real Currency Data: Money Create DATABASE: The

How the database uses tables when storing data: Columns are called fields in the database Rows are called records in the database Data type: Character data type: char, varchar, etc. Date Time Data: datetime, etc. Numeric type: int, float, real Currency Data: Money Create DATABASE: The primar

Tags: style blog http io using ar strong file data1. Select the database used by biAs a bi system, the use of a powerful background database software is essential. There are many database products with high performance and stability, such as IBM DB2, Oracle, GP and so on. These databases are commonly used in everyday e

How to clear the execution plan of an SQL statement in the share pool in Oracle 11g In the past, if the execution plan was slow due to binding snoop on Oracle 10 Gb database, you wanted to clear the execution plan of an SQL statem

modifications, it became the following (I executed the ALTER DATABASE DataFile ' sql> ALTER DATABASE open;ALTER DATABASE Open*An error occurred on line 1th:ORA-01113: file 1 requires media recoveryORA-01110: data file 1: ' C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM. DBF '

.dbf' size 20 M reuse Undo tablespace UNDOTBS1 Datafile '/u01/app/oradata/hsj/undotbs01.dbf' Size 200 M reuse autoextend on maxsize unlimited; Spool off 6. Go to sqlplus and execute the database creation script. @ Createdb. SQL 7. If an error is reported, check the createdb. log alert log and trace log. 8. Go to the $ ORACLE_HOME/rdbms/admin directory and run the SQL