Oracle

Select Table_name,tablespace_name,temporary from user_tables where table_name like '%prov% 'Analysis:TABLE_NAME: Table name (VARCHAR2 (30));Tablespace_name: Table space to store table names (VARCHAR2 (30));Temporary: Whether it is a temporary table (

The two are totally different things.Cursors are based on the query result setLet's say that one of your SELECT statements queries a result set of several records, and if you want to make a judgment or other action on each row in the result set,

Failure phenomena:Sql> Connect Scott/scottERROR:Ora-01017:invalid Username/password; Logon deniedSql> Connect Scott/scottERROR:Ora-28000:the account is lockedIndicates that the Scott user in Oracle was locked after 10 times because of the wrong

First truncate is a DDL statement, and delete is a DML statement.The deletion of truncate is much faster than delete, especially when the amount of table data is large, because Truncate does not produce undo during execution, so truncate can no

Installation environment: RHEL 6.4 x86_64Oracle 11.2.0.1 R2System Requirements:Memory: >1gSwap space: Typically twice times memory (memory size * *)HDD: 5G or moreInspection order;Memory#grep Mentotal/proc/meminfoSwap space#grep

Create or replace procedure Drop_all ascursor Cur_obj is SelectUO. object_name, UO. Object_type fromuser_objects UOwhereUo. object_name notinch('Drop_all') and UO. Object_type notinch('LOB'); /*cursor cur_tablespace is select UT. Tablespace_name

[Email protected] ~]$ export ORACLE_SID=ORCL[Email protected] ~]$ Sqlplus/as SYSDBASql*plus:release 10.2.0.1.0-production on Mon Nov 10 23:04:36 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to an idle instance.sql> startup

This article was reproduced from: http://www.cnblogs.com/linjiqin/archive/2011/04/18/2019990.html1. Transactions are used to ensure consistency of data, consisting of a set of related DML statements that are either fully or completely canceled by

A background process is a process that is implicitly executed by an Oracle server. When the routine is started, Oracle not only allocates the SGA, but also starts the background process, and when the routine is closed, Oracle releases not only the

Create a temporary table spaceCreate temporary tablespace test_tempTempfile ' D:\oracle\data\test\test_temp.dbf 'Size 32mAutoextend onNext 32mExtent management Local;Create a data table spaceCreate Tablespace Test_dataLoggingDataFile '

When oracleSession is locked A problem often occurs. A table in oracle cannot be updated suddenly, either through pl/SQL Developer or through sqlplus, the execution of the update statement or the execution of the select * from table_name for update

Oracle zookeeper ******************************************** ×Î ü ün § Ï ° Oracle zookeeper â £**ú ************************************* * ° Á when Oracle 10g £° ° then ± £° Oracle _ 10g_10.2.0.20.win32 ££ £? ° ² × ° Í ê é° ózant?ó ó Ó PL/SQL

Oracle zookeeper ******************************************** ×Î ü ün § Ï ° Oracle zookeeper â £**ú ************************************* * ° Á when Oracle 10g £° ° then ± £° Oracle _ 10g_10.2.0.20.win32 ££ £? ° ² × ° Í ê é° ózant?ó ó Ó PL/SQL

ORA-12520 error solved one Problem description: An error was reported when I suddenly found a connection to the database today. When I use pl/SQL dev to connect to data, sometimes I can connect to the database. Sometimes I can report the following

Step-by-step explanation of ORACLE (Lecture 1) Oracle was not used for a long period of time due to work reasons. Recently, it took some time to learn and record what you learned so that you can consolidate it in the future (taking 10 Gb as an

DBA_Oracle DBA partition concept Summary (concept), dba_oracledba 2014-06-20 BaoXinjian I. Summary Some maintenance operations on table partitions: Note: select a partition based on the actual situation. Table partitions have the following

Oracle-stored procedure exercises -- ==================================================== Stored Procedure = ========================================================== =======/ ** scm_iss.test_imit_pro1 * No parameter Stored PROCEDURE */create or

YourSQLDba sets the shared path backup and yoursqldba path backup YourSQLDba can back up a database to a network path (shared path). This feature is also very flexible and has never been used before. Due to a recent requirement, so I tested

Modify the size of oracle redo log files and oracle redo log files Create 3 new log groups SQL> ALTER DATABASE ADD LOGFILE GROUP 4 ('/u01/app/oracle/oradata/orcl/redo06.log') SIZE 500 M; SQL> ALTER DATABASE ADD LOGFILE GROUP 5

Oracle _ advanced subqueryZookeeper Oracle _ advanced subquery ① SubqueryA subquery is another SELECT statement nested in an SQL statement.Subquery (internal query) is executed before the master query is executed.Main query (external query) uses the