conn
create index and rebuild index on the original table will be added when the 4 locks on obj $ plus 3 locks to prevent DML operations on the original table create index online and rebuild index online using a temporary table to deal with new or to re-c ...
Test the executable process in the move operation. Summary: 1. In the move process can execute queries, do not go away regardless of the index, but not for dml operations 2.move completed, the index into the UNUSABLE state, taking the index of the qu ...
1. Basic operation SQL> sqlplus / nolog SQL> conn / as sysdba SQL> alter user hr account unlock SQL> alter user hr identified by hr SQL> grant DBA to hr SQL> conn hr / hr Select * from user_tables Select * from dba_tables SQL> re ...
Would like to test the next ora-01555 error, so the undo_retention set to 100. After the implementation of the conn scott / tiger create table t as select * from dept; Keep the insert revealed SQL> insert into t select * from t; 57344 rows created ...
Would like to test the next ora-01555 error, so the undo_retention set to 100. After the implementation of the conn scott / tiger create table t as select * from dept; Keep the insert revealed SQL> insert into t select * from t; 57344 rows created ...
One problem: there is no value on the query plan may affect the implementation of ORACLE. Problems reproduced as follows: SQL> conn ysp / ysp Connected. SQL> DROP TABLE TEST PURGE; Table dropped. SQL> CREATE TABLE TEST (ID CHAR (8), COLNO VA ...
A few days ago when use of dbms_job.remove remove the job encountered ORA-23421 error: ORA-23421: job number string is not a job in the job queue Cause: There is no job visible to the caller with the given job number. Action: Choose the number of a j ...
JOB when comparison in import and export special, met today did not expect a problem, just about collate records. JOB Oracle generated the id in the database is unique. All information is stored in the SYS JOB's JOB $ table, primary key ID genera ...
A few days ago when use of dbms_job.remove remove the job encountered ORA-23421 error: ORA-23421: job number string is not a job in the job queue Cause: There is no job visible to the caller with the given job number. Action: Choose the number of a j ...
Correct modification and SYSMAN password DBSNMP DBSNMP password changes 1.Stop dbconsole 2.set new password for dbsnmp 3.test dbsnmp new password by connect 4.edit targets.xml Search for the line: <Property NAME="UserName" VALUE="6f ...
/ * Create Date: 2010.6.28 Create user: Joshua zou Purpose: Use dbms_profile locate the stored procedure or package in a low efficiency statement Table: select * from plsql_profiler_data; select * from user_source; select * from plsql_profiler_units; ...
Brief explanation: The reason is this: EM has its own configuration file emoms.properties, After you open will find these: oracle.sysman.eml.mntr.emdRepPwdEncrypted = TRUE oracle.sysman.eml.mntr.emdRepPwd = xxxx, xxxx, xxxx, xxxx This shows that the ...
Oracle recommends to grant permissions to users, giving users the minimum permissions to complete the operation. Should try to avoid ANY system that contains the user to grant privileges such as SELECT ANY TABLE, CREATE ANY TABLE and so on. These inc ...
rnrnrnrn Send mail to create an instance of <br /> common Package: create or replace package xx_mail_api is procedure sendmail (p_err_buf out varchar2 , P_ret_code out number , P_sendor in varchar2 , P_recipients in varchar2 , P_subject in varchar2
In Linux, when using SQL * PLUS, history does not provide a callback function, and sometimes inconvenient. In order to use the Up and Down Arrow call history command, you can install rlwrap the software. rlwrap, the program itself is a Shell, you can ...
oracle database character set change A, oracle server-side character set query select userenv ('language') from dual Which is server-side character set NLS_CHARACTERSET NLS_LANGUAGE form for the server-side character display B, query oracle c ...
connection and the relationship between session 1. Official explanation: 1.1 connection: A connection is a physical path from a client to an Oracle instance. A connection is established either over a network or over an IPC mechanism. A connection is ...
1, switching servers archive mode, if you have a file pattern can skip this step: % Sqlplus / nolog (start sqlplus) SQL> conn / as sysdba (to connect to the database as DBA) SQL> shutdown immediate; (now closed database) SQL> startup mount ( ...
1. Set / etc / oratab testdb2: / opt/oracle/product/9.2.0: Y The last option should be changed from N Y 2. Test dbstart and dbshut command dbstart and dbshut will check / etc / oratab settings, if set to Y, then the implementation or off, if set to N ...
1. Set / etc / oratab testdb2: / opt/oracle/product/9.2.0: Y The last option should be changed from N Y 2. Test dbstart and dbshut command dbstart and dbshut will check / etc / oratab settings, if set to Y, then the implementation or off, if set to N ...
1, the simplest shell in call sqlplus. $ Vi test1.sh #! / Bin / bash sqlplus-S / nolog> result.log <set heading off feedback off pagesize 0 verify off echo off conn u_test / iamwangnc select * from tab; exit EOF $ Chmod + x test1.sh $ ./test1.sh Sec
Oracle's a bug need to modify the hidden parameter ALTER SYSTEM SET "_cursor_features_enabled" = 10 scope = spfile; In this machine (version 10.2.0.1 of the) test, the prompt * Error Line 1: ORA-02065: illegal ALTER SYSTEM option In a 1 ...
The Oracle RMAN backup Study Notes The Oracle RMAN backup Study Notes (Transfer from: http://lanmh.javaeye.com/blog/288830) 1. In linux. Find /-name rman displayed: / Home/oracle/product/10.20/sysman/admin/scripts/db/rman / Home/oracle/product/10.20/bin/r
oracle disable the operating system authentication login: WINDWOS Platform: To the oracle installation directory cd% ORACLE_Home% / network / admin directory, find a sqlnet.ora file (if not, you can manually create) Edit the following: # This file is ...
Have a windows environment, filled with 10g database reports filed after the inspection log to the host about a dozen left a letter M into a archive file check to see if there are two instances instance of the situation, first cut the old archive to ...
TEST for the newly created user a user. SQL> CONN TEST / TEST Connected. First, create the appropriate combination of the partition table SQL> SET TIMING ON SQL> CREATE TABLE TEST 2 PARTITION BY RANGE (OBJECT_ID) 3 SUBPARTITION BY HASH (DATA ...
Oracle Database 10g provides a significant improvement tools: Automatic Workload Repository (AWR). Oracle recommends that users use this to replace Statspack. Oracle AWR is essentially a built-in tools, which collect performance-related statistics an ...
Although there spauto.sql can, but I still like to use this script to collect information, more intuitive rn rn #! / Bin / bash rn rn ORACLE_HOME = / u01/app/oracle/11.2 if [$ @-gt 1] then echo "bad usage" eliff [$ @-eq 1] then case "$ ...
How to determine whether the oracle instance is running rn ORACLE instance starts, you must define ORACLE_SID. TOM on oracle ORACLE_SID explained that under the SID of the hash to uniquely determine the address of an instance. When we open sqlplus / ...
Import oracle of the exp file, this error message encountered the following: IMP-00017: following statement failed with ORACLE error 907: "ALTER TABLE" user_ITEM "MODIFY (" AVAILABILITY "DEFAULT '+'" IMP-00003: O ...
Oracle Database log files are missing line treatment Test 1: Clear the log using the command group method 1, see the original data in the table SQL>; conn test / test Connected. SQL>; select * from test; TEL ---------- 1 2 3 2, insert new data SQL&g
◆ 1, switching servers archive mode, if you have a file pattern can skip this step: % Sqlplus / nolog (start sqlplus) SQL> conn / as sysdba; (to connect to the database as DBA) SQL> shutdown immediate; (now closed database) SQL> startup moun ...
The oracle set to archive mode is the method First manually create archive directory, start adjusting the way oracle oracle set to archive mode Manually create the archive directory on the main server $ Cd $ ORACLE_BASE # $ ORACLE_BASE points to the ...
ORACLE create a user SQL> CONN SYS AS SYSDBA Enter password: *** Connected. SQL> CREATE USER SMIS INDENTIFIED BY SMIS; CREATE USER SMIS INDENTIFIED BY SMIS * ERROR line 1: ORA-00922: missing options, or this option is invalid, please trouble yo ...
Oracle recent study of c + + programming interface, OCCI, he had made a simple wrapper class source code posted for your reference. This program has not been rigorously tested, only interested in actions, and all business so if you want to, need to f ...
Oracle Package What effect? Simplify the application design, to improve application performance, achieve information hiding, overloading subprogram. Here are some of the code package. create or replace package FirstPage is - Author: MECON - Created: ...
The establishment of the table: SQL> create table CD_BILL_LOG 2 ( 3 BILL_ID NUMBER, 4 DEAL_EMP_ID NUMBER, 5 REACH_DATE DATE, 6 DONE_DATE DATE, 7 BILL_STATUS VARCHAR2 (10), 8 DEAL_DEPT_ID NUMBER, 9 SIGN NUMBER, 10 REMARK VARCHAR2 (50) 11) 12; Build ...
1, oracle92 installation if a clean machine, generally have their way, and finally through the dbca configuration. If you have previously installed oracle10client and so on, leading to environmental variables affect on oracle92 after, dbca tools such ...
Today: colleagues reported that can not connect Oracle, an error message is: ORA-00257 archiver error. Connect internal only, until freed Oracle documentation perspective, because the log file filled the disk, log on to the server, a look, really ful ...
rn rn Reprinted: http://xuehu2009.javaeye.com/blog/444820 rn Study: Happy Angel rn System environment: 1, the operating system: Windows 2000 Server, the machine memory 128M 2, Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition 3, the installati ...
Can use the profile to the number of each user's access be restricted. create profile ses_conn limit sessions_per_user n; n is the need to limit the maximum number of visits. Completed the profile and then assign it to users who need to limit the ...
rn Today ITPUB see a post on EXP, the question is as follows: rn http://www.itpub.net/showthread.php?s=&postid=5433382 # post5433382 rn Strange problem, the table does not exist there can export tips rn $ Exp system / manager parfile = parfile.tx ...
In the metalink note 116540.1 pointed out that if the create or replace view later, the view corresponding loss of privileges, it would be a bug. First of all: ask this question, the user a create a view v, give the user b: grant select on v to b, th ...
Because of the lack of understanding of public authority, in a trial on the authority, I executed the following statement revoke select any table from public; caused serious consequences - all of the package failure! This morning, made a very stupid ...
Given the non-archive mode, the current online log file is a bad approach. Problem Description: Help break through the collapse of the system, oracle9 get up, non-archive mode Microsoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microso ...
oracle database through the sqlnet.ora file parameters SQLNET.AUTHENTICATION_SERVICES, PFILE (or SPFILE) file parameters REMOTE_LOGIN_PASSWORDFILE and password file PWDsid.ora three synergies to achieve authentication. SQLNET.AUTHENTICATION_SERVICES ...
rn rn SQL> conn tes9 /"!@#$%^&*()_+=-'/?;:' \ +-_;'@" Connected. SQL> rn In addition to not use double quotes, the other will do rn
LOGMINER tool is installed in front of here is a brief introduction to SYS user to perform the following two script A: $ ORACLE_HOME / rdbms / admin / dbmslm.sql, used to create DBMS_LOGMNR package SQL> @ dbmslm.sql Package has been created. Succe ...
Command line to create oracle text index and the task of sample Founder Li Shouliang 2004 1 to dba as the user on the ctxsys unlock, set password sqlplus / nolog conn / as sysdba - The ctxsys user to unlock, set password ALTER USER "CTXSYS" ACCO
