exclude parameter in Oracle EXP Datapump


expdp dumpfile=<file_name>.dmp exclude=TABLE:\"IN \(\'<table_name1>\',\'<table_name2>\',\'<table_name3>\'\)\"   schemas=<user_name>


Note :- If original Export used INDEXES=n, then Data Pump uses the EXCLUDE=INDEX parameter. If original Export used INDEXES=y, then Data Pump uses the INCLUDE=INDEX parameter".

Comments

Post a Comment

Popular posts from this blog

finding fragmentation at table level and tablespace level in Oracle and steps to remove them

Use this query :- select owner,table_name,blocks,num_rows,avg_row_len,round(((blocks*8/1024)),2)||'MB' "TOTAL_SIZE",     round((num_rows*avg_row_len/1024/1024),2)||'Mb' "ACTUAL_SIZE",     round(((blocks*8/1024)-(num_rows*avg_row_len/1024/1024)),2) ||'MB' "FRAGMENTED_SPACE"     from all_tables  WHERE Owner NOT IN (        'SYS', 'OUTLN', 'SYSTEM', 'CTXSYS', 'DBSNMP',        'LOGSTDBY_ADMINISTRATOR', 'ORDSYS',        'ORDPLUGINS', 'OEM_MONITOR', 'WKSYS', 'WKPROXY',        'WK_TEST', 'WKUSER', 'MDSYS', 'LBACSYS', 'DMSYS',        'WMSYS', 'OLAPDBA', 'OLAPSVR', 'OLAP_USER',        'OLAPSYS', 'EXFSYS', 'SYSMAN', 'MDDATA',        'SI_INFORMTN_SCHEMA', 'XDB', 'ODM'); Or This one :- It will collect the data which ...
Read more

Oracle Custom Procedure for defragmentation Partition tables and their associated index and move non partitioned table

create or replace procedure sp_process_move_data as lv_tablespace varchar2(100) := '<tablespace_name>'; lv_objects_owner varchar2(100) := '<schema_name>'; lv_sql varchar2(100); type lr_user_segments is record ( segment_name user_segments.segment_name%type, segment_type user_segments.segment_type%type, segsize number, partition_number number); type lt_user_segments is table of lr_user_segments index by binary_integer; type lt_user_tab_partitions is table of user_tab_partitions%rowtype index by binary_integer; type lt_user_indexes is table of user_indexes%rowtype index by binary_integer; type lt_user_ind_partitions is table of user_ind_partitions%rowtype index by binary_integer; la_user_tab_partitions lt_user_tab_partitions; la_user_indexes lt_user_indexes; la_user_ind_partitions lt_user_ind_partitions; la_user_segments lt_user_segments; procedure log_msg(pv_msg in varc...
Read more

ORA-01153: an incompatible media recovery is active standby database oracle

ORA-01153: an incompatible media recovery is active SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;  2 ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE * ERROR at line 1: ORA-01665: control file is not a standby control file SQL> SELECT database_role FROM v$database; DATABASE_ROLE ---------------- PRIMARY SQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY; ALTER DATABASE CONVERT TO PHYSICAL STANDBY * ERROR at line 1: ORA-01126: database must be mounted in this instance and not open in any instance SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area  535662592 bytes Fixed Size                  1345376 bytes Variable Size             331352224 bytes Database Buffers     ...
Read more