ORACLE DBA

Oracle Data Pump is a newer, faster and more flexible alternative to the "exp" and "imp" utilities used in previous Oracle versions. In addition to basic import and export functionality data pump provides a PL/SQL API and support for external tables. Table Exports/Imports Schema Exports/Imports Database Exports/Imports INCLUDE and EXCLUDE Network Exports/Imports (NETWORK_LINK) Flashback Exports Miscellaneous Information Data Pump API External Tables (Unloading/Loading Data Using External Tables) Help expdp impdp Data Pump Enhancements in Oracle Database 11g Release 1 (expdp and impdp) Data Pump Enhancements in Oracle Database 12c Release 1 (expdp and impdp) SQL Developer 3.1 Data Pump Wizards (expdp, impdp) Transportable Tablespaces Getting Started For the examples to work we must first unlock the SCOTT account and create a directory object it can access. The directory object is only a pointer to a physical directory, creating it does not ...

Views are known as logical tables. They represent the data of one of more tables. A view derives its data from the tables on which it is based. These tables are called base tables. Views can be based on actual tables or another view also. Whatever DML operations you performed on a view they actually affect the base table of the view. You can treat views same as any other table. You can Query, Insert, Update and delete from views, just as any other table. Views are very powerful and handy since they can be treated just like any other table but do not occupy the space of a table. The following sections explain how to create, replace, and drop views using SQL commands. Creating Views Suppose we have EMP and DEPT table. To see the empno, ename, sal, deptno, department name and location we have to give a join query like this. select e.empno,e.ename,e.sal,e.deptno,d.dname,d.loc         From emp e, dept d where e.deptno=d.deptno; So everyt...