This post is going to explain about the Oracle Data Pump. We may find n number of articles on Google regards, Oracle DataPump. Let’s add one more. Being Oracle DBA we must explore Oracle RDBMS as much as possible to be veteran in our field. Normal water become Lemonade after adding lemon as we can see the […]
Articles Tagged: Datapump
Views_as_tables Parameter In Datapump Of Oracle 12c
VIEWS_AS_TABLES parameter has been introduced in datapump of 12c. With this, we can export a view from a source database and import as a table in a target database. Create a view: SQL> create view dba_view( emp_number) as select emp from dbatool;SQL> create view dba_view( emp_number) as select emp from dbatool; View created. SQL> select owner,object_name,object_type from dba_objects […]
LOGTIME=ALL Parameter In Datapump Of Oracle 12c
Introduction: – As Oracle user, we are learning Oracle export/import from 9i still changes are going on. 12c has introduced LOGTIME=ALL Parameter In Datapump. We are going to know about LOGTIME=ALL Parameter In Datapump in 12c. Data Pump Export is a utility for unloading data and metadata into a set of operating system files called a dump file […]