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: impdp
Network link in expdp
The export operation is performed with data that is consistent up to the specified SCN. If the NETWORK_LINK parameter is specified, then the SCN refers to the SCN of the source database. Follow following steps to the export database using network-link. Source database: demo Target database: uat Database platform : 11.2.0.4.0 Step 1 : Create a tnsnames.ora […]
Export backup with date and time
Data Pump Export (hereinafter referred to as Export for ease of reading) is a utility for unloading data and metadata into a set of operating system files called a dump file set. The dump file set can be imported only by the Data Pump Import utility. The dump file set can be imported on the […]
Importing just 1 view via impdp
Hi, Struggling the right syntax in Unix environment for importing a lost view, here is the proper way: impdp user/password@database directory=dir_dump dumpfile=dump.dmp logfile=imp_MY_VIEW.log INCLUDE=VIEW:\”= \’MY_VIEW\’\” job_name=imp_MY_VIEW
Oracle Import(parameters)
In this article, we are going to learn about the parameters of Import Oracle Datapump. Parameter Description abort_step undocumented feature access_method data access method : default is automatic attach attach to existing job : default is no cluster start workers across cluster: default is y content content to import : default is ALL data_options Import data […]
Oracle Export(parameters)
11g Oracle database’s Export parameters In this article, we are going to learn about the parameters of Export Oracle Datapump. Parameter Explanation abort_step Undocumented feature access_method Data access method – default is automatic attach Attach to exiting job -default is no cluster Start work across cluster- default is yes compression Content to export, default is metadata […]
Oracle and it’s different Versions
Oracle Database Technology – the Oracle server versioning Oracle Version 2 – first commercial RDBMS Oracle Version 3 – rewritten in the C programming language Oracle Version 4 – improved query performance Oracle Version 5 – added a networking stack for client-server computing Oracle Version 6 – OLTP improvements, Oracle parallel server Oracle Version 7 – first “Modern” Oracle New security model […]
Logical Backup
What is a logical backup? Logical backups are backups in which the export utility (for example Exp) uses SQL to read database data and then export it into a binary file at the operating system level. You can then import the data back into a database using the import utility (Imp).The Oracle Export Utility can […]