Hi,
Good days

I'm using Sybase ASE 15.0.2. / ASE 15.0.3

How can we load single table from database dump file.
In documentaion I've read that
A new ASE 12.5 feature allows database dump files to be "mined" for a
single table.
Thus an entire database loaded is not required when only a single
table restore is needed.

The feature is called 'archive database'. It allows you to access a DB dump
file directly, i.e. without really loading it first (you must still run
'load database', but it will be very fast irrespective of the size of the
dump).
See http://www.sybase.com/files/Product_...ewfeatures.pdf
for details.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

"hitgon" <hitgonase (AT) gmail (DOT) com> wrote