1, in the deletion of the user can not proceed smoothly, the ora-14452 error SQLgt; dropuserggtransfer2cascade; dropuserggtransfer2cascade * ER
1. the user cannot be successfully deleted, and the ora-14452 error SQLgt; drop user ggtransfer2 cascade;
During Oracle data restoration today, we found that the restored data is incorrect and there are repeated records. Query the relevant information and know that the user corresponding to the database should be deleted before restoration.
Kill Oracle processes with locks
There is often a problem: in Oracle, a process that has been set to "killed" locks system resources for a long time and does not release them. There is a better way than restarting the database, the process is
The previous article talked about the daily maintenance commands of Linux and the daily maintenance commands of oracle. I believe that Oracle databases must be maintained more or less. Should I import and export Oracle databases? (Oh, you said you
Note: The answer is after the option
Q. 1: The default tablespace clause in the create user command sets the location 1. Database Objects created by the user2. Temporary Objects Created By the User3. System Objects Created by the user4. None of
1. A ora-14452 error occurred while deleting the user.
SQL> drop user ggtransfer2 cascade;
Drop user ggtransfer2 cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-14452: attempt to create, alter or drop an index on
In many cases, exceptions or program errors may cause individual processes to occupy a large amount of system resources. To end these processes, run the following command to Kill the process:Alter system kill session 'Sid, serial #'; However, this
One
Check Database Basics
1.1. Check the Orale database instance status:
1.1.1 Select v.instance_name,v.host_name,v.startup_time,v.status,v.database_status from V$instance v;
--status represents the current instance state of Oracle (open
ORACLE12C database Management Common statements:Select name from V$database; #查看数据库名:Desc v$database;Select instance_name from V$instance; #数据库实例名The above three SQL statements can only be queried to the current connected instance and to the
If you use a SET TRANSACTION statement, then it must is the first statement in your transaction. However, a transaction need not has a SET TRANSACTION statement.Syntaxset_transaction::=http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_
13, management data concurrency--lock1. Lock mechanismAdvanced Data concurrency ProcessingUse row-level locking when inserting, updating, and deletingQuery does not require any locksAutomatic queue ManagementHold locks until transaction processing
How Oracle Stops a job1 related tables, views2 Problem descriptionWork with coworkers to resolve a SQL insert operation that takes an extra long time because of poor network connectivity.Since the network is not working well, you have chosen to use
Query and delete of Oracle's next session1. Query the current sessionsql> Select username,sid,serial# from v$session where username are not null; USERNAME SID serial#------------------------------ ---------- ----------SYS 144 4HYL 146SCOTT 147HR 159-
? Describes locking mechanisms and how Oracle manages data concurrency processing? Using SQL to manage Data? identify and manage PL/SQL Objects? Describe triggers and trigger events? Monitoring and resolving locking conflicts
Working with
Forum for help
Last week, CD channel ZSL contact me, let me see him in the forum sent a help post "oracle11.2.1 entire library export can not use ", told me this is the actual work encountered problems, for this reason, the user's data has not been
first, start, close the database
1, start the various modes of the instance
1 start the instance, load and open the database
This is the most common database operation, meaning that an instance has been started and the database has been loaded and
Errors such as Ora-00054:resource busy and acquire with nowait specified often occur when a database user inserts, updates, deletes a table's data in a database, or adds a table's primary key or a table's index.
The main reason is that a
--The vast majority of dba/all/user/v_$/gv_$/session/index begins with a view--dba_tables means all the relational tables that the DBA has or can access. --All_tables All relational tables that a user has or can access. -User_tables means all the
In the modern multi-user multitasking system, there will inevitably be multiple users accessing a shared object at the same time, this object may be a table, row, or memory structure, in order to solve the data security, integrity and consistency of
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.