Oracle

Oracle cannot EXPORT large empty tables by default. Solution: ORACLE 11G cannot EXPORT empty tables when using EXPORT. There is a new feature in 11G. When the table has no data, no segment is allocated to save space. Solution: 1. insert a row and

Oracle queries table space usage and queries which database instances are running Query table space usage 　　 Select a. tablespace_name "tablespace name ", 100-round (nvl (B. bytes_free, 0)/a. bytes_alloc) *) "usage (% )", Round (a. bytes_alloc/10

Excel-based oracle import methods Excel-based oracle import methods1. Same as the db2 import Method2. Use sqlldr to load data:1) Save the excel file as a. csv file and separate the text files with commas (,), such as table.csv.2) Compile an insert.

SQL statement for querying by page in Oracle Database Query SQL statements by page in the oracle database tutorialOracleSelect *From (select rownum r, t1. * from table name t1 where rownum Where t2.r> = m For example, to retrieve 10 or 20 records

  Create or replace procedure pro_test Is Begin Select * from t_test; End pro_test; Is this stored procedure correct? Yesterday, this was a long delay (the select statement was used in a stored procedure, but neither the cursor nor the into

Oracle alter statement usage SQL>SQL> create table bar (n number ); Table created. SQL>SQL> alter table bar add c char (1 ); Table altered. SQL>SQL> drop table bar; Table dropped. SQL> Add a Date Field SQL>SQL> create table bar (n number )

UPDATE statement.　　The UPDATE statement specifies the following information:　　This is the name of the changed table, where the record is changed, the list of column names, give them new content values, according to the specified conditions, you can

Oracle connection appears ora-12154 After rac is configured, both nodes can be pinged with tnsping, but the following error occurs when connecting with sqlplus.[Oracle @ rac2 admin] $ lsnrctl status LSNRCTL for Linux: Version 9.2.0.4.0-Production on

This is some simple notes for me to learn about oracle. I mainly talk about Oracle startup and stop. If you are a beginner like me, please refer to them. Log on to LNINMS1 using oracle. 1.1 Start and StopLog on to LNINMS1 using oracle. 1.1.1

This article introduces how to use the substr () string truncation function in oracle and plsql. If you need it, you can refer to it. Syntax The Code is as follows: Copy code Substr (string, start_position, [length])

This article introduces the oracle ora-01172, 01151 troubleshooting detailed tutorial, students in need can refer to about 01151 troubleshooting methods. The windows blue screen is displayed on the client, and the client deletes the screen randomly

I operate on the same server according to the link above. I succeeded, but I operate on the same server (that is, SQL Server and oracle are on the same machine, and different machines are waiting for experiment, all are 32-bit machines ). However, a

This article introduces the REF Cursor usage in oracle. If you need it, refer to the example. 1. What is a REF cursor?A temporary object that dynamically associates with the result set. That is, the query is dynamically determined during running. 2.

For more information about Oracle basic statement instance code, see. Basic Oracle statements   1. Enter the interface   Go to the sqlplus interface of oracle in cmd: sqlplus scott/orcl @ orcl   2. Connection Management   Connection command conn

This error is often in the database recovery, often encounter the following ORA-600 6002 error, which is a common, can be analyzed to eliminate one of the errors, Next let's look at the solution. The following are recent errors in user data recovery:

The following summarizes a large number of solutions to Oracle Chinese garbled characters. If you encounter such problems, refer to them. AMERICAN_AMERICA.WE8ISO8859P1, this character encoding is the Western European character encoding,

The following describes the Import and Export instances. The import and export operations can basically be completed. Because the Oracle Database Import and Export Office uses two Commands: exp export and imp import, the operation method is quite

This article describes how to implement the ORACLE decimal and binary conversion functions. Decimal conversion binary The Code is as follows: Copy code Create or replace function NUMBER_TO_BIT (V_NUM NUMBER)Return varchar is

This article to introduce you to modify props $. NLS_CHARACTERSET caused by ORA-00900 exception recovery, need to know friends can refer. Today a friend and I said his database can not open, open process prompts ORA-00900 error, by analyzing the

I will not talk about the role of the over () function in oracle. Next I will share my understanding of the over () function usage and some examples of over () function applications. Example 1 The Code is as follows: Copy code