Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How ASE15.0.2/ASE15.0.3 database dump files to be "mined" for a single table.

2 posts in Backup and Recovery Last posting was on 2009-12-24 08:04:23.0Z
hitgon Posted on 2009-12-24 07:24:03.0Z
From: hitgon <hitgonase@gmail.com>
Newsgroups: sybase.public.ase.backup+recovery
Subject: How ASE15.0.2/ASE15.0.3 database dump files to be "mined" for a single table.
Date: Wed, 23 Dec 2009 23:24:03 -0800 (PST)
Organization: http://groups.google.com
Lines: 11
Message-ID: <8cb91ef0-aa83-4a3a-9e96-50d7dcb08382@h14g2000pri.googlegroups.com>
NNTP-Posting-Host: 121.246.75.178
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1261639443 31382 127.0.0.1 (24 Dec 2009 07:24:03 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 24 Dec 2009 07:24:03 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: h14g2000pri.googlegroups.com; posting-host=121.246.75.178; posting-account=rWxUCQoAAAAM00_DJSjhLwHP6etRGODN
User-Agent: G2/1.0
X-HTTP-UserAgent: Opera/9.25 (Windows NT 5.2; U; en),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!h14g2000pri.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4077
Article PK: 48165

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.


Rob V [ Sybase ] Posted on 2009-12-24 08:04:23.0Z
Reply-To: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.backup+recovery
References: <8cb91ef0-aa83-4a3a-9e96-50d7dcb08382@h14g2000pri.googlegroups.com>
Subject: Re: How ASE15.0.2/ASE15.0.3 database dump files to be "mined" for a single table.
Lines: 42
Organization: Sypron BV / TeamSybase / Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b332087$1@forums-1-dub>
Date: 24 Dec 2009 00:04:23 -0800
X-Trace: forums-1-dub 1261641863 10.22.241.152 (24 Dec 2009 00:04:23 -0800)
X-Original-Trace: 24 Dec 2009 00:04:23 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:4078
Article PK: 48166

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_Overviews/ASE1502_newfeatures.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@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

"hitgon" <hitgonase@gmail.com> wrote in message
news:8cb91ef0-aa83-4a3a-9e96-50d7dcb08382@h14g2000pri.googlegroups.com...
> 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.