Data_as.docVIP

Oracle Concept: An Oracle database server consists of an Oracle database and an Oracle instance. Every time a database is started, a system global area (SGA) is allocated and Oracle background processes are started. The combination of the background processes and memory buffers is called an Oracle instance. A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. Each user owns a single schema. Schema objects can be created and manipulated with SQL and include the following types of objects:Tables/views/Stored functions, procedures, and packages/synonymsoracle 创建一个用户就创建了一个与之相关的schema。 SID 和service name 指的就是一个database的实例。 用SYSDBA的角色登录，就可以创建用户。 普通用户登录，可以看到他有权限看到的内容。 一般，这个用户只看到他自己的schema。 一个schema就是一些tables views procedures 等的集合。 一个oracle instance 就是一个database server。包括物理的存储和进程。 一个orcale instance等同于一个mysql的安装。 oracle中的schema就是mysql中的database。 sqlplus 是oracle的一个客户端。 登录sqlplus：sqlplus /nologconn username/password@connectionnameconn sys/oracle@115.perf as sysdba Oracle special SQL/sys Tables Desc tablename Select * from all_tables where owner=username; 主外键约束的信息存在view user_constraintsselect * from user_constraints where R_CONSTRAINT_NAME in (select constraint_name from user_constraints where table_name = DEPT) ;查看所有 reference DEPT表的外键删除所有表的外键约束： SELECT object_name, object_type FROM user_objects Oracle grant/revoke privileges /oracle/grant_revoke.php Oracle create/drop user create user {0} identified by {0} default tablespace usERS temporary tablespace tEMP profile dEFAULT; -- Grant/Revoke role privileges grant connect to {0}; grant dba to {0}; grant resource to {0}; -- Grant/Revoke system privileges grant unlimited tablespace to {0}; drop user user_name cascade; Oracle Exp/Imp 文件格式是二进制的 需求：1)迁移某oracle数据库用户下所有非用户数据的结构(即包括：table,index,procedure等等除了表数据以外的所有该用户的结构).2)迁移该用户下的指定的一部分表的用户数据。测试环境：solaris9+oracle817 to redhat2.1+oracle817==========================