Oracle

How Does Oracle create a user and grant access permissions to other user tables?  -- Step 1: create a user Create User Username identified by password; -- Step 2: assign a contact lock value to the user (only grant the session permission) Grant

Connectionstring = "Password = czh; user id = czh; Data Source = (description = (address_list = (address = (Protocol = TCP) (host = 192.168.168.211) (Port = 1521) (CONNECT_DATA = (Server = dedicated) (SERVICE_NAME = skydream )));" HOST: Server IP

  The Oracle version in this document is 11.2.0.1. No OEM was installed before. An error is reported when dbca is used for installation today. The error page is as follows:     I have previously reviewed an OEM reconstruction method: Oracle OEM

 1. Oracle 11G default audit description An article on auditing is as follows: Oracle Audit audit description Http://blog.csdn.net/tianlesoftware/article/details/4712932 On Maclean's blog, I saw two articles about Oracle 11G default audit. The

1. If the DDL syntax is correct, implicit commit will occur even if the execution fails: Duzz $ Scott @ orcl> Create Table T1 as select * from Dept;   Table created.   Elapsed: 00:00:00. 03 Duzz $ Scott @ orcl> Update T1 set loc = 'xx' where deptno =

Suppose a subprogram declaresINParameter,OUTParameter, andIN OUTParameter. When you call the subprogram,INParameter is passed by reference. That is, a pointer toINActual parameter is passed to the corresponding formal parameter. So, both parameters

Record the experiment that we just created to configure multiple listeners for a database (t02). The process is a little tortuous.   (1) added two test listeners. The configuration content of listener. ora (you can manually edit the file or use

I just tested a program and reported an error saying that the data was not found: Rochelle date1! = L_date2L_date1 = 26-May-11, l_date2 = 26-May-11 ...... It turns out that it was nls_date_format. Oracle uses built-in programs such as

Continue is a new feature brought in Oracle 11g, but there is a trap or bug need to pay attention, see the following code scrap: Declare cursor dept_cur is select deptno , dname , Loc from Scott. dept; type dept_tab is table of dept_cur %

When handling exceptions, pay special attention to the use of when others then, because when others then will eat all the exceptions. If no information is thrown after when others then, that is, when others then null, this may greatly increase the

Program name: xblo (JSP + servlet + JavaBean + Oracle single user blog)========================================================== ======================================Program version: 0.1 (20100912)===================================================

1. delete/truncate: only delete data. The index structure is not deleted. Drop will delete the table structure and the index/constrain/trigger that depends on the table. The procedure/function will be retained, but will change to the invalid state;  

  Archive logs record database operation records, which are the basis for data recovery. If the archive mode is enabled for the database, a large number of archive logs will be generated. Of course, if there is an RMAN backup, logs that have been

1. Use high-speed storage devices to improve read/write capabilities, such as EMC and netapp,   2. If no data exists in Table tab1Drop table tab1;Create Table tab1 as select * From tab2;Then, create an index   3. Use the hint prompt to reduce the

Oracle Management Server ConfigurationTo configure the Oracle Management Server, follow these steps: 1. Use Enterprise Manager Configuration assistant to create an archive database You can choose to create a database instance or create a database (

  Many of my friends only use Oracle to delete the system. However, in many cases, he may find that the next installation page disappears when the system is re-installed, and he may have to reinstall the system, in fact, this is not the case if your

You cannot start em, and then check the information on the Internet. The solution is as follows: C: \> set oracle_sid = demo C: \> emctl start dbconsoleProductname configuration issue. D: \ oracle \ product \ 10.2.0 \

Since Oracle's $7.4 billion acquisition of sun, Oracle China has begun to fully integrate sun China. On September 6, the reporter learned through relevant channels that some staff from Sun China's marketing department had left. Some industry

First, execute the following code to get the locked process: select t1.sid, t1.serial#, t1.username, t1.logon_time from v$session t1 , v$locked_object t2where t1.sid = t2.session_id order by t1.logon_time; Obtain the SID and serial # Serial

In work, you often need to determine the type of columns in the table according to the actual situation. The following table records the description of column types in oralce. Field Type Description