oracle study guide

can start by using the "Oracle 11g", "Application Development", "SQL Developer or SQL Plus" connection in the application. note for the first time, when you use SQL Developer, you are prompted to specify the path to Java.exe, so don't specify your own java_home here (I just don't know, specify a JDK6, end up saying incompatible.) The following JDK paths can be used with the Oracel installation path specifically: of course, if you are not careful, c

object permissions (the data Permissions for object manipulation) Data objects include: tables, stored procedures, views, functions, sequences, triggers, roles, table spaces, jobs, packages, etc. 7.oracle User Password Management Implemented by creating a profile file, which is a collection of commands that are password-constrained, resource-constrained (1) Account lockout Create Profile Rule AAA: User three password error, account locked for two da

) + ') ' when @c_type = ' char ' then ' char (' +convert (varchar (2), @max_length) + ') ' When @c_type = ' text ' Then ' long '--here to map for further data types Else ' # # ' end) + (case if @is_nullable =1 then ' null ' else ' NOT null ' End ' + ', ' FETCH NEXT from Columns_cursor to @column_id, @c_name, @c_type, @max_length, @precision, @scale, @is_nullable END/********5. Output Build Table statement *********/Select Left (@cons_sql, Len (@cons_sql)-1) + '); '/********6. Releasing cursors *

business, you understand.9, if you buy Oracle, generally must also buy services, Oracle charges are very expensive, also not too chip to make this money (7x24 hours, very tired), technical support in China has a lot of companies, such as: http://www.gzbosheng.com/ This is a small, no-small company (more in Beijing), with a total of 20 people (basically one person serving a company), but if your company is

Oracle Study--DBCA Build library errorSystem environment:Operating system: RedHat EL54Oracle:oracle 11gR2Failure phenomena:After installing the 11GR2 software ready to create the database through DBCA, execute DBCA with the following error:[Email protected] ~]$Dbcaoracle Net Services Configuration:# # An unexpected error have been detected by HotSpot Virtual machine:# # SIGSEGV (0xb) at Pc=0xa44b13a8, pid=2

Oracle Study Notes: sqlplus User Logon 1 sqlplus Login Local login (log on to the database server) Oracle Logon Sqlplus account name/password as role name 1.1 sys Login Example: sqlplus sys/oracle ERROR: ORA-28009: connection as SYS shocould be as SYSDBA or SYSOPER The sys administrator must have the sysdba role. [

The installation of ODI is very simple, all the way next. However, the JDK must be installed before installation, and JDK 8 is used here. Download the following jar files from the Oracle official website as shown in:Install using the following command:[emailprotected]:~$ java -jar software/fmw_12.2.1.3.0_odi.jar 启动程序日志文件为/tmp/OraInstall2018-01-18_03-07-30PM/launcher2018-01-18_03-07-30PM.log。正在提取安装程序... . . . . . . . 完成检查 CPU 速度是否大于 300 MHz。 实际为 2892

the data easy to distinguish, while making the display more eye-catching, you can set the query display mode!First, the view----"toad options, and some of the other things in this interface are the alignment settings.　　After setting the effect is obviously much better!　　1.4 Set how query records are displayedMouse over to the field----"Right-click on Excel. You'll find a triangle on the field. Click on a column of the triangle, you can do some filtering functions, the most useful is to put whic

: Network Disk DownloadContent IntroductionEditing the volume of information contained in this book can improve your programming skills to a new level. You'll learn how to write dynamic PL/SQL programs and Oracle database interfaces, perform complex computations, and use advanced techniques to control error conditions. In addition, you will receive up-to-date information on Pl/sqltoolkit,java integration and performance optimization.

Tags: password SOP Create administrator Oracle Install ASE DBA Maintenance OTT1,oracle installation is complete when you create a DB instance, the Sys,system,scott is generated automatically2,sys user Super Administrator with highest Oracle privileges, SYSDBA role with CREATE DATABASE permission, default password manager3,system User is the Operation administrato

Oracle study Case-controlfile diversity on RawSystem environment:Operating system: AIX 5300-08Database: Oracle 10.2.0.1After building the library through DBCA, there are two control files, and then add a control file [[emailprotected]:/home/oracle] $sqlplus '/ASNBSP;SYSDBA ' sql*plus:release10.2.0.1.0 -Productiono

Tags: OracleOracle study--rman enable block change tracking errorSystem environment:Operating system: RedHat EL6Oracle:oracle 11g R2Target Db:prodCatalog DB:ORCLAfter making an incremental backup using Rman Backup, a ORA-600 error occurred while starting "Block change tracking"!Case Analysis:1. Enable block change tracking11:23:43 [email protected] Prod>alter Database enable block change tracking using file '/HOME/

oledb is used onlineIt does not cause an error or exception, but the write value is abnormal. String strsql = "insert into Table1 (ID, name) values (table1_seq.nextval,: name)ReturningIDInto: ID "; ---------------------------------------------ASP. NET 2.0 + Oracle 11g sample download point at (7) of this post (the latest sequence value is obtained immediately after batch addition + addition ):Http://files.cnblogs.com/WizardWu/081128.zip-------------

Oracle Study Notes: Use of the graphic management tool EM Use of common Oracle learning notes tools-EM Graphics Management Tool em Server 1 Ensure Listening Starts -----> grid Lsnrctl status Or Netstat-tunlp | grep 1521 If not Lsnrctl start 2. Ensure database startup ----> oracle Sqlplus/as sysdba If not started Shu

production environment business, you understand.9, if you buy Oracle, generally must also buy services, Oracle charges are very expensive, also not too chip to make this money (7x24 hours, very tired), technical support in China has a lot of companies, such as: http://www.gzbosheng.com/ This is a small, no-small company (more in Beijing), with a total of 20 people (basically one person serving a company),

userGrant CONNECT,RESOURCE,DBA to Shgbyp;--Import and exportImp shgbyp/[email protected] file= "E:\20170310.dmp" Full=y ignore=y--The corresponding delete table spaceDrop tablespace SOA including contents and datafiles--Delete UserDrop User SHGBYP CascadeHere is the emphasis: delete user Shgbyp, just delete the user under the schema objects, do not delete the table space assigned to the user. Should be for the table space is only for your users, you do not have a user only represents this table

Case study of ORACLE Database disconnection When I got off work last night, I was about to shut down the ORACLE database on the local virtual machine, and then I was about to get off work. But because I opened multiple windows in SecureCRT, I accidentally got the result, by mistake, I executed the shutdown immediate command on a production server. It took about 6

Tags: Oracle--oracle Data Block (block) with Case study tuningData Block Overview Oracle manages the storage space in a database data file (datafile) as a data block. A data block is the smallest (logical) unit of data in a database. Corresponding to the data block, the smallest physical storage unit of all data at the

Previous:Oracle DBA Study Notes-start and close DatabasesNext article: Oracle DBA Study Notes-log files (using logminer to analyze logs) 1Control File Control File Information:The size of the control file is related to the settings when the database is created. (1)Database creation time information (2)Database Name, table space name (3)Related data file,

Oracle programming art study notes, configuration environment, successfully developed Oracle Applications, SELECTFORUPDATESKIPLOCKED, Oracle files, Oracle files Oracle programming art study