Oracle

Environment: Linux System Tools: PL/SQL DEVELOPER First step: See the name of the tablespace and where it is located: Select Tablespace_name, file_id, file_name, Round (bytes/(1024*1024), 0) Total_space From Dba_data_files ORDER BY Tablespace_name

http://blog.bossma.cn/database/some-oracle-storing-process/Several common Oracle stored proceduresDate: January 6, 2008/Category: DataBase/ 7,268 views/CommentsBeginner Oracle, learn about Oracle's stored procedures, run a few examples, and make a

1. Benefits of Automatic data file expansion1) does not appear because there is no remaining space available to the data cannot be written2) Minimize man-made maintenance3) can be used in databases where important levels are not very large, such as

1.hibernate calling stored procedures various methodsHttp://www.cnblogs.com/jerryxing/archive/2012/04/28/2475762.htmlIf the underlying database (such as Oracle) supports stored procedures, you can also perform bulk updates through stored procedures.

(formerly Chenbo) Abstract: In various fields, the use of the database is increasing: More enterprise-level databases are used, the use of diversification, database capacity to increase the trend is obvious. At the same time, the application based

Using spool to export data is sometimes a good choice, 70,000 data export needs 10s, note that the need to use @d:/spool.txt call,set Termout off will not take effect does not display to the screen. A semicolon is appended to the SQL statement and

Create a test tableCreate Table test_img ( ID integerprimarykey, name VARCHAR2(+), image blob);Storing picturesImportJava.io.FileInputStream;Importjava.io.FileNotFoundException;Importjava.io.IOException;ImportJava.io.InputStream;ImportJava.

When you update the same row of records concurrently, the post-update connection needs to wait for the first update to commit or roll back. 3 Graphs to help understand: 1 , New command window, update id=1 line, there is echo can continue to execute

Create a test tableCREATE TABLE test_img ( ID integer PRIMARY key, name varchar2 (+), image blob);Storing picturesImport Java.io.fileinputstream;import Java.io.filenotfoundexception;import Java.io.ioexception;import Java.io.inputstream;import

Open Sqlplus at night enter the user name and password will not always be logged, as the previous line of code "ora-01034:oracle not available" error Solution Ideas:1, check whether the service is started,2, if it has been started, the database does

In OracleRowNum, how many records are now in the output result set that match the Where condition.RowNum in the Where condition can be understood in this wayThe rownum in select can be understood as putting this record in the output result set,

Create Tablespace (Tbs_school)Create Tablespace Tbs_schoolDataFile ' D:\oracle\product\11.1.0\oradata\schooldb\school01.dmp 'Size 10m autoextend on;Create User (user name: ABC password: ABC)Create user ABC identified by ABCDefault Tablespace

----Create a new service, Pmon will automatically (dynamically) register to Tnslsnr after creation, the service created is not permanent and will be lost after the database restarts.To persist requires the use of ALTER system set service_names= ' xx

First, create a table:CREATE TABLE test ( ID number (+) NOT null primary key, name VARCHAR2 (32));Then, customize a sequence (sequence)CREATE SEQUENCE test_sequenceincrement by 1--each time you add a few start with 1--counting from 1 nomaxvalue--

Notes on common Oracle commands Login without a password: sys as sysdba View all current databases: select */name from v $ database; View the current database connection user: show user View All Tables of the current data: select table_name from

When the oracle10G tablespace is moved, all applicable routines of the TNS listener cannot establish a new connection. The parameters of the service_died12537 and c3p0 connection pool One Oracle O & M experience while learning and working, step by

Oracle uses spool to export data Using spool to export data is sometimes a good choice. It takes 10 s to export 70 thousand pieces of data. Note that you need to use @ d:/spool.txt to call it, set termout off will take effect and will not be

ORACLE11G from scratch-20141128 1. Oracle Database Overview 1.1 structure and composition Oracle Database 11G has four editions: Enterprise Edition, Standard Edition, Standard Edition 1, and individual edition. 1.1.1, Enterprise

Solution for extracting & quot; Chinese Characters & quot; strings from ORACLE strings In actual work, I often use the function of removing special characters, especially the data inserted into the database. To ensure the quality of the data, we

About the mongolerman archive deletion policyRMAN> show all;Configure archivelog deletion policy to none; By default, the archive deletion policy is not configured in oracle10g 11g; In this case, how does one Delete archive logs that have not been