Oracle Export Import table structure

//Export a table from a specified database to a file #>ExpSs_hr/Ss_hr@10.231.221.30:1521/SshrFull=NTables=(Report_table)File='Report _ table. dump'
 

 //  Export multiple tables in the specified database to one file #  Exp Ss_hr / Ss_hr@ 10 . 231.221 . 30 : 1521  / Sshr Full  =  NTables(Ar_summary_c11, ar_mac_records_c11, ar_mac_records_c11)  File  =  'Ar _ mac_records_c11 + ar_mac_records_c11 + ar_summary_c11.dump '
//Exports a table from a specified database to a file.
#ExpSs_hr/ss_hr@10.231.221.30: 1521/sshrTables= Ar_mac_records_c11File= 'Ar _ mac_records_c11.dmp'
 

 
Export only the table structure file name: table_structure_sshr.dmp # exp ss_hr/Ss_hr @10.231.221.30:1521/SshrOwner= Ss_hrRows = N File= Table_structure_sshr.dmpLog =Table_structure_sshr.log
 

 Import a single file #IMPSs_hr /Ss_hrFile = '  C: \ Users \ administrator. Cici-think \ ar_mac_records_c11.dmp  '   Touser = Indonesia/Indonesia full = Yimport: Release  11.2 . 0.2 . 0 -Production on Tuesday February 5   23 : 13 : 32   2013 Copyright (c)  1982 , 2009 , Oracle and/ Or its affiliates. All Rights Reserved. IMP - 00058 : Oracle Error 1017  Ora - 01017 : Invalid username/password; logon denied Username: Indonesia/Indonesia 

 

Import a single table to a DMP file # imp Indonesia/Indonesia@ XETouser=Indonesia file=F: \ ait \ lottes \ dB \ initialization database statement \Database\ Ss_hr.dmp tables=Sy_code_param
 

 

Report_table.dumpThe file is the table creation Statement (including the insert Statement)