Oracle

1.select Name,log_mode from V$database; NAME log_mode------------------------------------------QUERY noarchivelog 2. Using the archive Log LIST command Database log Mode No Archive Mode Automatic archival Disabled Archive

Synonyms concept The Oracle synonym (synonyms) is literally the meaning of the alias, and similar to the function of the view, is a mapping relationship. It can save a lot of database space, the operation of different users of the same table does

Table size that has two meanings. One is the amount of physical space allocated to a table, regardless of whether space is used or not. You can get the number of bytes in this query:Select Segment_name, bytesFrom User_segmentswhere Segment_type = '

Create materialized view [view_name]Refresh [Fast|complete|force][On [Commit|demand] |Start with (start_time) next (next_time)]As{Create a query statement for materialized views} These are the common syntax for Oracle to create materialized views (

For continuous updates, see the pages on https://hnuhell.gitbooks.io/oracle_errmg/content/or https://hnuhell.github.io/Oracle_ERRMG/. ORA-00000 to ORA-00877 ORA-00000: Normal successful completion (operation) Ora-00000:normal, Successful

A problem with the recent project is the need to get the field length defined by the table in the Oracle database, and then verify that the data that will be entered into the database table exceeds the length of the field definition. So understand

To use flashback, first start row movement: ALTER TABLE name enable row movement; Recover deleted and submitted data through the SCN 1. Get the SCN number of the current database Select Current_scn from V$database; (Switch to SYS user or System

Java JDBC Connection Oracle Execute Simple query Example: Package com.test.dbtest; Import java.sql.CallableStatement; Import java.sql.Connection; Import Java.sql.DriverManager; Import Java.sql.ResultSet; Import java.sql.SQLException; Import

1. Profiles and Users   Only one profile can be assigned to the user at a time. Profile: • Controlling resource consumption • Managing account status and password expiration   Note: The profile can enforce resource limits only if Resource_limit is

Oracle TRANSACTION Isolation mechanism Transaction ISOLATION Level: the degree to which a transaction's modifications to the database are isolated from another transaction that is parallel to it. With two concurrent transactions accessing the same

First, the causes of this error and related factors is due to "password_life_time=180 Day" set in default profile in oracle11g, which in Oracle 11g isThere is a password expiration problem. Second, the error phenomenon: When the user is locked out,

The native installation of Oracle, the default is the boot service, boot time is too slow, shut down, need to open the service: OracledbconsoleorclOracleoradb10g_home1isql*plusOracleoradb10g_home1tnslistenerORACLESERVICEORCL This behind the

In the Oracle server with SYS user login times wrong ora-00119,ora-00132, such asReading the newspaper wrong is the need to modify the configuration information of the parameter file network registration moduleThe first step: View the init.ora.418201

Recently found that WIN10 remote connection some Windows Server mstsc can not connect, but some windows2012 but can access, can not access all reported the following this error:Follow the prompts of the Microsoft address, looked at the bottom is the

What is predicate out of bounds? predicate out-of-bounds is the fact that the query condition of the SQL statement exceeds the scope recorded by the database statistics. predicate out-of-bounds causes the Oracle optimizer to incorrectly select the

Oracle Installation 11g:1. Download Oracle packages via official website www.oracle.com, with 1 and 2 respectively, with two extracted and merged together, for example:2. Attention before installation: Turn off the virus firewall to ensure that the

In connection with the database, sometimes encountered a "ORA12514: Listener currently does not recognize the service requested by the connection descriptor" error, which is actually the database dynamic registration (about dynamic registration will

Tag: INF appears in COM encryption Locator Group Policy requires ACL MDARemote Desktop Connection Error:Workaround :1. Enter Gpedit.msc in the run and start the local Group Policy Editor.2. Navigate to computer-Administrative

One: JDBC Connection database (Oracle Reference)public class DBTest {//testpublic static void Main (string[] args) {ResultSet rs = null;Statement stmt = null;Connection conn = null;try {Load DriverClass.forName

Original: http://www.cnblogs.com/hanzongze/p/oracle-catalog.html . NET Programmer's Oracle Series (1): Navigation directory . NET Programmer's Oracle Series (2): Preparing a test environment . NET Programmer's Oracle Series (3): Database