Here , I Explained about how to get the Binary export of a table in HANA Database using export utility.
Case Study : Binary export of the table from System SID !!!!
Binary export for the Single table .
export "Schema_Name"."Table_Name" as binary into 'PATH_DETAIL' ;
Example:
export "HANADBXY"."/1XT/D140/SID" as binary into xyz/HDB/BACKUP/;
Binary export for More then One tables at a time
export hanadbxy."SRIT_SEQ" "MSG", hanadbxy."SRIT_SEQ" "SEQ", hanadbxy."SRIT_MAP" as binary into xyz/HDB/BACKUP/ ;
Compress Binary Export
Compress directory into a single file, e.g.
tar czvf export.tgz export_dir_on_server
Case Study : Binary export of the table from System SID !!!!
Binary export for the Single table .
export "Schema_Name"."Table_Name" as binary into 'PATH_DETAIL' ;
Example:
export "HANADBXY"."/1XT/D140/SID" as binary into xyz/HDB/BACKUP/;
Binary export for More then One tables at a time
export hanadbxy."SRIT_SEQ" "MSG", hanadbxy."SRIT_SEQ" "SEQ", hanadbxy."SRIT_MAP" as binary into xyz/HDB/BACKUP/ ;
Compress Binary Export
Compress directory into a single file, e.g.
tar czvf export.tgz export_dir_on_server
No comments:
Post a Comment