Sometimes your load statement can abruptly terminate with following message:- ASE is terminating this process. If you try to bring the DB online following error message is received:- CT-LIBRARY error: ct_send(): network packet layer: internal Client Library error: State error: trying to write when connection is expecting a read. CT-LIBRARY error: ct_cancel(): network packet layer:…
It is possible to do a cross-platform dump and load procedure from any database dump that is at least at version 11.9.x, there are just some pre-requisites that must be met before the source database is dumped. The process requires that the database being dumped is in a quiescent state, i.e. there are no “open”…
Following command can be used to dump a Sybase ASE database into multiple stripes:- dump database to ‘compress::<dumpfile_path_and_filename>_01.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_02.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_03.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_04.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_05.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_06.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_07.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_08.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_09.dmp’stripe on ‘compress::<dumpfile_path_and_filename>_10.dmp’go Following command can be used to load a Sybase ASE database from multiple stripes:- load database from ‘compress::<dumpfile_path_and_filename>_01.dmp’stripe on…
Oracle Database Internal Mechanism 