Oracle

1 in data migration, users first have the right to modify the database, and the table space to create, delete and other rights For example: SELECT * from Dba_tab_privs where grantee= ' SCOT '; ---View Scott permissions (SYS user logon)

This article mainly describes the Oracle in the simple query and limited query, the following words not to say, come and see together. Sql: 1,DML (Data Manipulation language): mainly refers to the database query and update operation, query

Linux automatically backs up Oracle data: Once a colleague, back and forth operation of the development and production of the database, the results mistakenly deleted the production of the database, the mood I think not ordinary people can

Today found a small thing, feel very interesting, look for some information to share with you: In the Sqlplus: Tools provided by third parties (e.g. Plsqldev) Summarize: exec is a sqlplus command that can only be used in Sqlplus. Call is an

The knowledge points involved in Dbms_job 1. Create Job: variable jobno number; Dbms_job.submit (: Jobno,--job ' your_procedure; ',—-stored procedure executed, '; ' Cannot omit next_date,--next execution time ' interval '--each time

For the use of Oracle databases, it is important to create a table that meets your needs, so let's create the first table of our own There are two ways to create a table: (1) More needs to be created inside CMD (2) created in SQL Developer, and

Oracle is one of the most popular databases, powerful, excellent performance, relative to the difficulty of learning is not small. This article is to share some of their experience to everyone, to do a accumulation, to facilitate their own and other

I. Configuring System Parameters We need to configure the system parameters to be used before Oracle is installed 1. Modify System kernel Parameters modifying sysctl.conf files Add the following in the file/etc/sysctl.conf: Kernel.sem = 250 3200

The example in this article describes the Oracle stored procedure looping syntax. Share to everyone for your reference, specific as follows: 1. Simple cycle Grammar loop statements; End Loop; Example: Counter: = 0; Loop Counter:

Introduction to Oracle Analysis functions: In the day-to-day production environment, we have more contact with the OLTP system (ie, online Transaction Process), these systems are characterized by real-time requirements, or at least the length of

Some Oracle processes are killed, the state is set to "killed", but the locked resources are not released for a long time, sometimes there is no way, had to restart the database. Now provides a way to solve this problem, which cannot be killed in

This article summarizes the Oracle mathematical correlation functions. Share to everyone for your reference, specific as follows: 1. Absolute value: ABS () Select ABS ( -2) value from dual; 2. Take the whole function (big): Ceil ()

The Oracle tutorial you are looking at is: Oracle Application Experience (2). ------who is accessing the database? Select C.sid, C.serial#,c.username,a.object_id,b.object_name, C.program,c.status,d.name,c.osuser From V$locked_object A, All_objects B,

The Oracle tutorial you are looking at is: Oracle initialization parameter settings. ALTER DATABASE datafile ' D:ORANTDATABASEUSER1ORCL. ORA ' RESIZE 1000M; CREATE tablespace index_data datafile ' d:orantdatabaseindex_data ' SIZE 500M; ALTER

To move a data file from one path to another in a user's table space One, for the offline of the non-system table space This example moves Oracle's case table space (example table space) from D:\ORADATA\ORCL\ move to D:\ORACLE\ORADATA\ 1. View

The Oracle tutorial that you are looking at is Oracle Dynamic Cross table generation. Oracle is the most widely used large database, and in the paradigm of Oracle database design can greatly reduce data redundancy, so that the database maintenance

1. Add a column:Alter table name add column name varchar2 (10);2. Modify a column:　　Alter Table name modify column name varchar2 (20);3. Delete a column:　　Alter table name drop column name ;Here are a few places to note, first, add and modify the

After the DML operation is committed, the restore segment used by the operation can be used by other objects, and in order to ensure that the data is still saved in the restore segment during the flashback operation, the undo_retention parameter may

A customer's exadata environment causes database downtime due to a large number of hardware faults. After analysis, it is confirmed that a disk of a cell node has an exception, leading to someAfter the disk of the cell node is offline, the asm

I. Query recently executed SQL statementsSelect SQL _text, last_load_time from v $ SQL order by last_load_time desc; SELECT SQL _text, last_load_time FROM v $ SQL WHERE last_load_time is not null and SQL _text like 'Select % 'ORDER BY last_load_time