Oracle

Installation platform centos6.5 + Oracle 11gStatement: This article for their own notes collation, non-complete installation steps, for reference only;;;Step one: Specify the host name and planning IP address (requires a system restart)Hostname:

One, temporary table spaceThe temporary tablespace contains only the ephemeral data generated during the session, improving the concurrency of multiple sort operations that cannot be done in memory, while also improving the efficiency of space

This function is in its own misoperation, will some data changes wrong, you want to restore the data before the change wrong, this time you can use this method but it is recommended to carefully change the data, if it is necessary to update, please

Http://blog.sina.com.cn/s/blog_4df2251d0100hkzv.htmlFirst step, on the cmd command line, enter SqlplusStep two, follow the prompts to enter the user name and password1. View processes and Sessions parametersSql> Show parameter processesNAME TYPE

OracleDatabaseBackup and Restore commandsData export:1 full export of database test, user Name System Password Manager exported to D:\daochu.dmpExp System/[email protected] file=d:\daochu.dmp full=y2 Exporting the system user in the database to the

Question 1:The most recent write service needs to use Arcengine to connect to the Oracle database, which will pop up a form before connecting to the database. Then you can connect it after filling it up, so it's troublesome.The code is as follows:

In Oracle, it is sometimes used to return a result set with a function, and here is the demo: 1234567 create or replace type t_test as object(id integer,create_time date,object_name varchar2(60));create or replace type

One of the Buddies raised a question:There is a table, and the order of the columns when created is A,b,cWhen using SELECT *, the order in which the columns are displayed is a,c,b and must be queried using SELECT *, and the table cannot be

Oracle text and format string mismatch resolutionDate-Time type for OracleRemember to use the To_date () method when inserting data into the date type of Oracle.such as insert into Cuslogs (STARTTIME) VALUES (to_date (' 2009-5-21 18:55:49 ', '

The Expdp:sql command executes only once and does not need to be executed again.Mkdir/home/oracle/backupchmod 777/home/oracle/backupSql> Create directory Expdir as '/home/oracle/backup ';Sql> Grant Read,write on the directory Expdir to Deepradar;Sql>

1. Select permissions for all tables give the userGrant Select any table to user2.revoke Entity permission name |all on entity name from user name | role name |public;Alter any cluster modify the permissions of any cluster alter ANY index modify the

Upload the Oracle installation file to the Linux server first1. Unzip the zipUnzip Linux.x64_11gR2_database_1of2.zipUnzip Linux.x64_11gR2_database_2of2.zip2. Create the installation directoryMkdir/opt/oracle3. Create a user group:Groupadd

Create a database1 Creating an Oracle database using the Database Configuration Assistant toolStep One Action windowThere are 4 choices. A CREATE Database B metabase option C Delete database D Administrative TemplatesStep Two Database Template

Querying tables in the lock tableselect     l.session_id sid,      l.locked_mode,     l.oracle_username,      l.os_user_name,     s.machine,     s.terminal,      o.object_name,     s.logon_time,      s.serial#  from     v$locked_object l,     

ORA-08002 appears: Sequence xxxxxxx.currval has not been defined in this process.Cause: Because it is the current value of the first query sequence, there is no value of the cache sequence before the memory, so you need to first queryThe next value

There is no self-increment field in Oracle, which can be implemented indirectly via sequence + trigger, Sqlplus login in cmd and run directly. It usually takes a few steps:1 Creating a data sheetCreateTable test_increase (             userid number (

Go home every day to play until 9:30 to say ...Today, another class in NetEase Cloud class, from a simple query began to talk about1, distinct to heavy, as if no difference2, alias, there is no difference3, arithmetic, same4, the connector, has seen

Design of the databaseThe process of software development:Project--Requirements analysis--design, detailed design----implementation---maintenance[including database design]Through demand analysis, we can extract the "entity classes" in the key

1. Check the status of the main library:Sql> SELECT switchover_status from V$database;Switchover_status--------------------To STANDBY2. Set the main library to standby roleALTER DATABASE commit to switchover to physical standby;Shutdown

1. Query the sname, Ssex, and class columns of all records in the student table.2, the inquiry teacher all units namely does not duplicate depart column.3. Query all records of student table4. Query all records from 60 to 80 of the scores in the