drop user cascade drop user and the difference between

2010-10-19  来源:本站原创  分类:Database  人气:180 

drop user; just delete the user,

drop user × × cascade; will delete the user name and view all the tables.

user

Specify the user to be dropped. Oracle Database does not drop users whose schemas contain objects unless you specify CASCADE or unless you first explicitly drop the user's objects.

CASCADE

Specify CASCADE to drop all objects in the user's schema before dropping the user. You must specify this clause to drop a user whose schema contains any objects.

Parameter can be deleted using the cascade of all the user objects. To note the following:

1 If the user's schema contains tables, then Oracle Database drops the tables and automatically drops any referential integrity constraints on tables in other schemas that refer to primary and unique keys on these tables.

If the user's schema in the table, then delete the table automatically deleted when the table associated with the primary key and foreign key.

2 If this clause results in tables being dropped, then the database also drops all domain indexes created on columns of those tables and invokes appropriate drop routines.

If the user's schema in the table, then delete the table automatically deleted when the index associated with the table.

3 Oracle Database invalidates, but does not drop, the following objects in other schemas:

Delete a user, the following objects in the other user will not be deleted in will only be set to invalid

1 Views or synonyms for objects in the dropped user's schema

Views, synonyms

2 Stored procedures, functions, or packages that query objects in the dropped user's schema

Stored procedures, functions, packages

4 Oracle Database does not drop materialized views in other schemas that are based on tables in the dropped user's schema. However, because the base tables no longer exist, the materialized views in the other schemas can no longer be refreshed.

Other users to create user-based materialized views are deleted are not deleted, but can not be refreshed.

5 Oracle Database drops all triggers in the user's schema.

User mode to delete all triggers

6 Oracle Database does not drop roles created by the user.

Deleted user created the other user will not be deleted

If the urer no tables and other objects you just created, you can use the drop user command to remove, or to use the drop user cascade command to delete, then the user will be deleted along with the object.

Transfer from http://hi.baidu.com/amingsc/blog/item/9aa3fc242c0c51094d088d56.html

相关文章
  • drop user cascade drop user and the difference between 2010-10-19

    drop user; just delete the user, drop user × × cascade; will delete the user name and view all the tables. user Specify the user to be dropped. Oracle Database does not drop users whose schemas contain objects unless you specify CASCADE or unless you

  • drop user and drop user cascade difference 2010-10-19

    drop user; just delete the user, drop user × × cascade; will delete the user name of all tables and views. user Specify the user to be dropped. Oracle Database does not drop users whose schemas contain objects unless you specify CASCADE or unless you

  • Eclipse drag and drop (Drag and Drop) (change) 2010-04-01

    Operating system is the most commonly used drag and drop movement of files to copy, drag and drop increased use of simple software. SWT also supports drag and drop, but more complicated programming. Figure 18.1 Schematic diagram of the realization of

  • js drag and drop drag and drop 2011-01-07

    Good tutorial http://www.webreference.com/programming/javascript/mk/column2/3.html // iMouseDown represents the current mouse button state: up or down /* lMouseState represents the previous mouse button state so that we can check for button clicks an

  • Oracle: drop user xx and drop user xx cascade difference 2011-05-19

    Oracle: drop user xx and drop user xx cascade of differences: SQL> drop user xx; drop user xx * ERROR at line 1: ORA-01922: CASCADE must be specified to remove the 'xx' SQL> drop user xx cascade; The user has discarded. ] [Explained drop user xx Spe

  • Definition. Modified. Delete table (transfer) 2010-11-06

    First, create a table (Creat Table) Can use the CREATE TABLE command to create a new table. This command is one of the most simple form: only the names of the columns defined, the type and size of the basic information. Syntax: CREATE TABLE <table na

  • drop table dept cascade constraints 2011-08-02

    My colleagues asked me drop table dept cascade constraints; keyword cascade constraints of the role. Should exist in parent-child table foreign key when the parent table when the cascading drop drop the child table's foreign key. Simply records the t

  • drop a user that is currently connected 2010-08-25

    SQL > DROP USER CASCADE USER1 ERROR: ORA-01940: cannot drop a user that is currently connected Since the current user is connected to the database , so not removed Solution: 1, check the user's session process, SQL> SELECT SID, SERIAL # FROM V $ SES

  • [DnD] Swing Drag And Drop Analysis Notes 2010-04-23

    DnD (Drag And Drop) for the program's user friendliness is essential Common to a file directly dragged into the programs, and to drag item from one list to another list The most a few days learning Swing's DnD mechanism, has been a mess, a stunned bu

  • DROP TABLESPACE when the data file is automatically deleted 2010-03-29

    DROP TABLESPACE when the data file is automatically deleted OMF OMF and non-management in the DROP TABLESPACE data files will automatically deleted when doing the test: SQL> alter system set db_create_file_dest = '/ oradata / data / standby' scope =

  • SQL Advanced usage constraints, Alter, Create, Drop 2010-06-22

    SQL PRIMARY KEY constraint PRIMARY KEY constraint to uniquely identify each record in a database table. Primary key must contain unique values. Primary key column can not contain NULL values. Each table should have a primary key, and each table can h

  • Flex 3 Getting Started (18): Building an advanced user interface, drag and drop support added 2010-08-26

    In a typical visual development environment, you can select in the application and drag an object moving back and forth on the screen. Flex Drag and Drop Manager allows users to select an object, such as an element of List control, or a control such

  • js to achieve simple drag and drop 2010-09-25

    The simplest implementation of js said drag and drop drag and drop, and now major, medium and small sites are essentially similar things, especially for pop-up layer drag, it is common mess. . . In fact, for pop-up layer, the initial aim is very simp

  • flex drag and drop operations (a) 2010-11-04

    Easier to make money at home Visual development environment, the biggest feature is an application that allows you the choice by the mouse, mobile and flexible to handle objects on the screen. Flex Drag and Drop Manager can select an object (such as

  • Oracle Flashback Flashback - restore error DML, DDL (Drop) operation 2010-12-22

    Human error is the failure of the database system is one important reason, according to the survey about 40% of the system is operational errors or user errors caused by human error and these are particularly difficult to avoid. Traditionally taken i

  • sqlserver中drop.truncate和delete语句的用法 2014-09-22

    这篇文章主要介绍了sqlserver中drop.truncate和delete语句的用法,本文图文并茂,内容清晰,需要的朋友可以参考下 虽然小编不建议大家去用命令删除数据库表中的东西,但是这些删除命令总有用的着的地方. 说到删除表数据的关键字,大家记得最多的可能就是delete了 然而我们做数据库开发,读取数据库数据.对另外的两兄弟用得就比较少了 现在来介绍另外两个兄弟,都是删除表数据的,其实也是很容易理解的 老大------drop 出没场合:drop table tb --tb表示数据表的名

  • 数据库中删除语句Drop.Delete.Truncate的相同点和不同点的比较(实例说明) 2014-11-05

    数据库中删除语句Drop.Delete.Truncate的相同点和不同点的比较,通过举例说明让大家了解 数据库删除语句的分别介绍: Delete:用于删除表中的行(注:可以删除某一行:也可以在不删除表的情况下(即意味着表的结构.属性.索引完整)删除所有行) 语法:删除某一行:Delete From 表名称 Where 列名称=值 删除所有行: Delete From 表名称 或 Delete * From 表名称 Drop:用于删除表(注:将表的结构.属性.索引也会被删除.) 语法:Drop T

  • Copy statement insert into table difference between the two 2011-03-25

    1.INSERT INTO SELECT statement, statement of the form: Insert into Table2 (field1, field2 ,...) select value1, value2, ... from Table1 Requires that the target table must exist Table2, Table2 as the target table already exists, so we insert the sourc

  • Difference between Access and Sql 2011-09-28

    like query with * SELECT * FROM flash WHERE filename like '* http *'; DELETE * FROM company_guangxi WHERE agency name not like '* company *' and agency name not like '* plant *'; Delete Query DELETE * FROM Orders WHERE orders under a single date <= #

  • Oracle Application of flip-flops 2010-03-31

    Trigger is stored in the database, and is implicit in the stored procedure execution. When a specific event occurs, Oracle will automatically trigger a response code. Trigger types can be divided into four kinds: 1. Data Manipulation Language (DML) t