Oracle

Oracle 11g, password is valid for 180 days, and is set to no-time and can be operated online.?Steps:-->> Access to Oracle UsersSu-oracle-->> SYS Super User login SqlplusSqlplus/as SYSDBA-->> View Password_life_time value defaults default,Select

1. View a table take up the tablespace size: SELECT bytes/1024/1024| | ' MB ', A.*from user_segments a WHERE a.segment_name = ' tl_sp_nonreal_list_201505 '; 103 Query Error single table space SELECT segment_name,sum (bytes)/1024/1024 from

problem: ORA-04031: Unable to allocate19204bytes of shared memory ("sharedPool","UnknownObject","SGA Heap (1,0)","Session param values") error Reason: The shared memory is too small, the memory allocated to the shared pool is not sufficient to

Create or replace procedure Remove_refund_his_pro isBeginDeclareCursor Refund_query_cur isSelect rowID from Ucmp_realtime_refund_query t1where t1.apply_tmTYPE Rowid_table_type is table of ROWID index by Pls_integer;V_rowid Rowid_table_type;BeginOpen

The following error was used today in the Oracle times: ora-28002:the password would expire within 7 days===============================================ERROR:Ora-28002:the password'll expire within 7 days==============================================

After successfully installing Oracle 11g, a total of 7 servicesThe meanings of these seven services are:1. Oracle ORCL VSS Writer Service:Oracle Volume Mapping copy write service, VSS (Volume Shadow Copy service) enables the creation of

The three complex type variables that are frequently encountered in the actual project. Combine some of the project examples to do a collation, the specific following: Record type: A record type can contain one or more members, and each

Problem descriptionFor example, the developer on the employee table to make an UPDATE statement, but after the update, only to find that the updated statement is incorrect, you need to undo the update operation just now. such as (update employee E

The Oracle default port number is 1521. It's easy for hackers to scan and remember your database every day.So it's necessary to modify the default port number.1. Check the listening status firstLsnrctl status2. Turn off monitoringLsnrctl stop3.

Both 1.rownum and rowid are pseudo-columns, but the root of the two is different, and RowNum is based on the results of the SQL query, assigning each row aThe logical number, different SQL will also cause rownum different, but ROWID is physical

I want to talk to you today about some of the knowledge I learned during this time using Oracle database.I recently came out to work, came to the company is used by the Oracle database, has been using SQL database, in the nature of the former is

Oracle Single data file expands beyond 32GThe tablespace data file capacity is related to the Db_block_size setting, which is specified when the DB instance is created. The Db_block_size parameter can be set to 4K, 8K, 16K, 32K, 64K, and so on,

Before Oracle 10g, multiple sessions of the same user can only use the same temporary tablespace because only one temporary tablespace is default to the user at a given time, in order to resolve this potential bottleneck, the Oracle support

I. Index organization table (index-organized table, IOT)An indexed organization table is a special kind of table that stores indexes and table data together. The data in the normal table is stored in the database in an unordered (Heap) manner.The

Today, learn about the creation of databases in Oracle database and the creation of tables, delete modifications, and so on. At the beginning, the database has not been connected, and later know that the original is a few services are not open:

CREATE tablespace DemoDataFile ' J:\app\wufan\oradata\orcl\demo01.dbf 'SIZE 50MEXTENT MANAGEMENT Local--must be managed locallySEGMENT SPACE MANAGEMENT AUTO; --ASSM Management of the logoCREATE TABLE Demotab (x number)Tablespace DemoSTORAGE (INITIAL

The caption is not descriptive enough, it should be a table with no data inserted (that is, a table that has been inserted, after which the number of rows deleted is 0 can be exported)Workaround:1. Execute SQL:Select ' '| | table_name| | ' allocate

To revoke management mode:The user has the flexibility to choose to use manual undo management (manual undo management) or automatic undo management (automatic undo management) by setting the Undo mode. The database system can run either in manual

SummaryThe NHibernate2.1.1 version can finally invoke Oracle's stored procedure, but must use the NHibernate.Driver.OracleDataClientDriver driver (Oracle.DataAccess.dll), but this will cause HBM2DDL.K Eywords throws an exception, so it's not perfect.

Oracle Operation Problems LinuxOracle11.2.0.3Problem:When sqlplus/assysdba executes starup, an error is returned: A: Check whether this parameter is set in sqlnet. ora. If SQLNET. AUTHENTICATION_SERVICES exists, it is set to ALL. If not, it does not