Re: Advice please - Backup Manager and settings

Hi Carl,

        If you only want to backup selected tables look into the use of the export and import utilities. An alternative you might want to consider is to create backups by spooling to a file and then selecting all of the data in a table. If you take this approach the restore operation is based on the use of SQL*Loader.

        If you can guarantee that the tables in question will not be updated during the backup (for instance if you are the only user) either approach will work.

regards

Jerry

Carl Sarelius wrote:
>
> Hi,
>
> I'm after some advice.
>
> I'm using PO8 in W95 with the standard setup (ie. default local database
> with demo tables). I have created some other tables that reside in the local
> db.
>
> What I want to do is a partial backup ie. only backup the tables that I have
> created. When I go into Backup Manager my Db Status says "Running in
> NOARCHIVELOG mode" and the Backup Type is "Offline - Full Database". I'm
> certain that I have to change one, if not both, of these parameters. My
> problem is, how do I do it? I've looked around within SysMgr at the commands
> available to me there but I can't seem to find what I'm after, and my manual
> is not that helpful.
>
> Could someone please advise me what I need to do, or the commands to be
> given, to allow me to do partial db backups.
>
> Thanks,
>
> --
> Carl Sarelius
> Carl.Sarelius_at_bigpond.com
> Melbourne, Australia

--

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_yahoo.com 	Opinions are mine not those of ICT Group