How to export [EXPDP] just Package ???

By -

  How to export[EXPDP] just Package:

===================================


Create PARFILE

==============

$ cat > new_tmp.par

USERID="/ as sysdba"

SCHEMAS=SPSE

INCLUDE=PACKAGE:"IN ('SPSE_ER_BOND_REPORT')"

COMPRESSION=ALL

CLUSTER=N

DUMPFILE=CFRAEXPORTS:tmp_new_expdp_10.dmp

NOLOGFILE=Y


Execute EXPDP using PARFILE

===========================

$ expdp parfile=/exports1/cfrabackup/new_tmp.par


Export: Release 11.2.0.4.0 - Production on Wed Sep 13 14:36:05 2017


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

FLASHBACK automatically enabled to preserve database integrity.

Starting "SYS"."SYS_EXPORT_SCHEMA_02":  /******** AS SYSDBA parfile=/exports1/cfrabackup/new_tmp.par

Estimate in progress using BLOCKS method...

Total estimation using BLOCKS method: 0 KB

Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC

Processing object type SCHEMA_EXPORT/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC

Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY

Master table "SYS"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded

******************************************************************************

Dump file set for SYS.SYS_EXPORT_SCHEMA_02 is:

  /exports1/cfrabackup/tmp_new_expdp_10.dmp

Job "SYS"."SYS_EXPORT_SCHEMA_02" successfully completed at Wed Oct


Plan | Travel | Adventure

Comments

Post a Comment

Popular posts from this blog

ORACLE FORMS AND REPORTS 12C INSTALLATION DOCUMENT LINUX

By -
Image
SOFTWARE REQUIREMENT: 1. Java ( jdk-8u65-windows-x64.exe ) 2 . Oracle Weblogic Server 12C( fmw_12.2.1.0.0_infrastructure_Disk1_1of1.zip ) 3. Oracle Forms and Reports 12c (12.2.1.0) ( fmw_12.2.1.0.0_fr_linux64_Disk1_1of1.zip ). Setup The following actions should be performed by the "root" user. Make sure the "/etc/hosts" file contains correct entries for both the "localhost" and real host names . 127.0.0.1      localhostlocalhost.localdomain localhost4 localhost4.localdomain4 Create a new group and user. groupadd -g 54321 oinstall useradd -u 54321 -g oinstall oracle passwd oracle Create the directories in which the Oracle software will be installed. mkdir -p /u02/app/oracle/product/12.2.1 mkdir -p /u02/app/oracle/config/domains mkdir -p /u02/app/oracle/config/applications chown -R applfrw:oinstall /u02 chmod -R 775 /u02/ Append the following entries into the "/home/applfrw/.bash_profile" file. # Adju...
Read more

Microsoft Office 2019 Installation Instructions for Windows

By -
open up cmd as admin and change directories to the folder with the setup.exe  run setup.exe /download configuration.xml it created a folder in the same directory with about 2gigs of data once done run  setup.exe /configure configuration.xml It ran the installer and finished. Volume Lisence :  Sign in to the VLSC. Select the Downloads and Keys tab. Find your Office 2019 product in the list and click its Key link. In the table beneath the name of the product,  find your product key in the column labeled Key.   Copy the product's individual key from this table and paste it into a program like Notepad or click Export all keys:  CSV just above the list of products to download a list of keys in comma-separated-values format (which can be opened with Excel).  Download the configuration files that you need from the table below by right-clicking the link for the file you need, selecting Save link as…,  and saving t...
Read more

installation of Oracle BI Publisher 10.1.3.4.1

By -
After the installation of Oracle BI Publisher 10.1.3.4.1, And the Installation was successful. These instructions are located in:  /home/oracle/OraHome_1/BI_Publisher_readme.txt At the end of this installation BI Publisher will be started. You may access it at the following URL: http://bipublisher.doyen3.com:9705/xmlpserver  as Username: Administrator Password: Administrator For security, follow the Preferences link and reset the Administrator password under the Account tab in the Preferences page. Refer to the install.htm or install.pdf on your installation media for additional instructions on completing the configuration of BI Publisher such as Installing and Configuring the Scheduler. If you selected Advanced Install, please see your Oracle Application Server documentation on how to start and stop applications. BI Publisher shows as xmlpserver in Oracle Containers for Java. If you selected Basic Install, the following commands will start and stop BI Pub...
Read more

Configure physical standby database Oracle Database 11G release 2 (11.2)

By -
This article presents how to configure physical standby database for Oracle Database 11G release 2 (11.2). It’s not focusing on transportation method, duplication method, protection modes nor extra functionality available for physical standbys. This presentation is based on the following article Install Oracle 11G Release 2 (11.2) on Oracle Linux 7 (OEL7). Architecture Final standby configuration is very simple: one host: oel7.dbaora.com – already configured with latest binaries Oracle Database 11G primary database: ORA11G listener LISTENER – already installed standby database: SORA11G – this article shows how to configure it standby configuration will work in default mode MAXIMUM PERFORMANCE standby_physical_11g_01 Configuration consists of the following steps: For primary database prepare space for archivelog and turn on archivelog mode switch to force logging on database level or tablespace level add standby redo logs prepare initialization parameters prepar...
Read more