set echo off;
Set pages 999;
set long 90000;
select dbms_metadata.get_ddl('TABLESPACE',tb.tablespace_name) from dba_tablespaces tb;



Create datapump directory

CREATE OR REPLACE DIRECTORY test_dir AS '/u01/app/oracle/oradata/';


GRANT READ, WRITE ON DIRECTORY test_dir TO scott;

nohup expdp \"/ as sysdba\"  schemas=SCN,FUND EXCLUDE=STATISTICS ACCESS_METHOD=EXTERNAL_TABLE directory=DATAPUMP  dumpfile=DATE_DBNAME_BACKUP.dmp logfile=SATINUAT_BACKUP.log   JOB_NAME=FULL_export_A3  &

Import   command

impdp   \"/ as sysdba\"   dumpfile=DATE_DBNAME_BACKUP.dmp  DIRECTORY=DATAPUMP logfile=SCNL1_schemas_backup_201805260200.log  remap_tablespace=SCN_IMAGE:Scn_TA CLUSTER=N


Comments

  1. we can use for windows machine
    expdp dumpfile scehmas=sss.sse dumpfile=xxx.dmp logfile=xx.log
    SYS@SMSPSETUP AS SYSDBA

    ReplyDelete

Post a Comment

Popular posts from this blog

How to check OS inventory