A fairly fast way to export and import a database

Microsoft Windows [version 10.0.10586]
(c) Microsoft Corporation. All rights reserved.

c:\windows\system32> sqlplus sys/[email protected] as SYSDBA

Sql*plus:release 11.2.0.1.0 Production on Friday August 26 10:59:42 2016

Copyright (c) 1982, Oracle. All rights reserved.

Connect to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options

sql> Create directory Exp_dir as ' C:\Zjzsmap\databak '; Note: C:\Zjzsmap\databak is where the file is stored

The catalog has been created.

Sql> Grant Read,write on the directory Exp_dir to Dd_gisqam; Note: Dd_gisqam table space name

Authorization is successful.

Sql> exit;
From Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options Disconnect

c:\windows\system32>EXPDP dd_gisqam/[email protected] directory=exp_dir DUMPFILE=DD_GISQAM160826.DMP schemas  =DD_GISQAM Logfile=dd_gisqam160826.log; Note: Export statements

Export:release 11.2.0.1.0-production on Friday August 26 11:04:43 2016

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

Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options
Start "Dd_gisqam". " Sys_export_schema_01 ": dd_gisqam/******** @orcl directory=exp_dir dumpfile=dd_gisqam160826.dmp schemas=dd_gisqam Logfile=dd_gisqam160826.log;
Estimating using the BLOCKS method ...
Working with Object Types Schema_export/table/table_data
Total estimate using the BLOCKS method: KB
Working with Object Types Schema_export/user
Working with Object Types Schema_export/system_grant
Working with Object Types Schema_export/role_grant
Working with Object Types Schema_export/default_role
Working with Object Types Schema_export/pre_schema/procact_schema
Working with Object Types Schema_export/sequence/sequence
Working with Object Types schema_export/table/table
Working with Object Types Schema_export/table/index/index
Working with Object Types Schema_export/table/constraint/constraint
Working with Object Types Schema_export/table/index/statistics/index_statistics
Working with Object Types Schema_export/table/comment
Working with Object Types Schema_export/procedure/procedure
Working with Object Types Schema_export/procedure/alter_procedure
Working with Object Types Schema_export/table/constraint/ref_constraint
Working with Object Types Schema_export/table/index/functional_and_bitmap/index
Working with Object Types Schema_export/table/index/statistics/functional_and_bitmap/index_statistics
. . "Dd_gisqam" was exported. " Am_attribute "6.968 KB 5 rows
. . "Dd_gisqam" was exported. " Am_article_type_group "6.953 KB 8 rows
. . "Dd_gisqam" was exported. " Am_field_enum "10.61 KB 18 rows
. . "Dd_gisqam" was exported. " Am_role "5.898 KB 2 rows
. . "Dd_gisqam" was exported. " Am_system_log "7.679 KB 2 rows
. . "Dd_gisqam" was exported. " Am_sys_enum_field_list "6.414 KB 4 rows
. . "Dd_gisqam" was exported. " Am_user "7.960 KB 1 rows
. . "Dd_gisqam" was exported. " Am_activity_details "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_appraisal "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_appraisal_list "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_article "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_article_history_file "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_article_link_entry "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_article_template "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_catalogue_code_list "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_category "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_category_description "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_category_group "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_custom_datum_category_group "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_data_field "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_data_filter "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_data_filter_frame_role "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_data_filter_role "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_datum_category "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_datum_category_group "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_datum_data_field "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_datum_group_pro "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_datum_pro "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_datum_pro_share "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_department "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_department_user "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_destroy "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_destroy_list "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_destroy_source "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_entrys_lidx "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_family_member "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_frame_role_privilege "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_land_use_detail "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_land_use_register "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_link_content "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_link_def "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_link_inherit "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_link_property "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_move_archives "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_move_archives_detail "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_query_result "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_register_backup_entry "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_role_privilege "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_r_backup_field "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_sparse_image_notes "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_spotcheck "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_spotcheck_problem "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_storage "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_sub_data_field "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_use "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_user_role "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_use_basefile "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_use_roll "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_use_roll_page "0 KB 0 rows
. . "Dd_gisqam" was exported. " Am_webservice "0 KB 0 rows
. . "Dd_gisqam" was exported. " T_idcard "0 KB 0 rows
The main table "DD_GISQAM" has been successfully loaded/uninstalled. " Sys_export_schema_01 "
******************************************************************************
Dd_gisqam. The sys_export_schema_01 dump file set is:
C:\ZJZSMAP\DATABAK\DD_GISQAM160826. DMP
job "Dd_gisqam". " Sys_export_schema_01 "completed successfully at 11:05:29 Note: Export succeeded

c:\windows\system32> IMPDP system/[email protected] Directory=exp_dir dumpfile=dd_gisqam160826.dmp; Note: Import statements

A fairly fast way to export and import a database