Re: Full export of a database.

From: Thomas Huewelmeier <thomas.huewelmeier_at_dresdner-bank.com>
Date: Wed, 19 May 1999 07:05:46 GMT
Message-ID: <7htns9$gs3$1@nnrp1.deja.com>

Hi,

you can export a database independent from other connected users as long as you use the option CONSISTENT=Y

import errors can result from the import options used, e.g. you exportet user X with grants, they imported user X with grants. Now they get an error for every user that is not in their database and user X ganted privileges to.
To avoid errors the import options have to fit to your export options.

T. Huewelmeier

In article <374029FA.A3F7E6BA_at_wanadoo.fr>, raymond garreau <raymond.garreau_at_wanadoo.fr> wrote:
>
> --------------7259B8A5A55EF562B34F38EE
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Is it necessary to have the data base closed to make a full export?
>
> I sent an export to our software company, for them to make tests, but
> they said they have errors when importing the file due to export made
> with an open database.
>
> Can anyone give me some hint about it?
>
> Thank you.
>
> --------------7259B8A5A55EF562B34F38EE
> Content-Type: text/html; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> <html>
> Is it necessary to have the data base closed to make a full
export?
> I sent an export to our software company, for them to make tests,
but
> they said they have errors when importing the file due to export made
with
> an open database.
> Can anyone give me some hint about it?
> Thank you.
>  
>  </html>
>
> --------------7259B8A5A55EF562B34F38EE--
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 19 1999 - 02:05:46 CDT