October 7th, 2008, 12:45 PM
| | |  LOAD with COPY
Hi!
If I do a LOAD .... COPY YES TO C:\DIR then in directory c:\DIR a file
is created. When can I delete that file?
Best regards,
Kovi
--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
|
October 7th, 2008, 07:35 PM
| | | Re: LOAD with COPY
On 7 Okt, 13:42, Gregor Kova <gregor.ko...@mikropis.siwrote: Quote:
Hi!
>
If I do a LOAD .... COPY YES TO C:\DIR then in directory c:\DIR a file
is created. When can I delete that file?
>
| You will need this file if you have to rollforward your database, thus
you should treat it as you do with your normal backup/logfiles. I'm
under the impression that it is acually a tablespace backup, but I
can't seem to find any references that support this assumption right
now.
/Lennart Quote:
Best regards,
* * * * Kovi
>
--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| *In A World Without Fences Who Needs Gates? * |
| * * * * * * *Experience Linux. * * * * * * * *|
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| |
October 8th, 2008, 07:35 AM
| | | Re: LOAD with COPY
OK, but if I do a full offline backup then I don't need the files
anymore, right ?
Lennart pravi: Quote:
On 7 Okt, 13:42, Gregor Kova <gregor.ko...@mikropis.siwrote: Quote:
>Hi!
>>
>If I do a LOAD .... COPY YES TO C:\DIR then in directory c:\DIR a file
>is created. When can I delete that file?
>>
| >
You will need this file if you have to rollforward your database, thus
you should treat it as you do with your normal backup/logfiles. I'm
under the impression that it is acually a tablespace backup, but I
can't seem to find any references that support this assumption right
now.
>
>
/Lennart
>
> Quote:
>Best regards,
> Kovi
>>
>--
>____________________________
>|http://kovica.blogspot.com|
>-----------------------------~-~-~-~-~-~-~-~-~-~-
>| In A World Without Fences Who Needs Gates? |
>| Experience Linux. |
>-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| >
| --
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~- |
October 8th, 2008, 05:25 PM
| | | Re: LOAD with COPY
On 8 Okt, 08:26, Gregor Kovač <gregor.ko...@mikropis.siwrote: Quote:
OK, but if I do a full offline backup then I don't need the files
anymore, right ?
>
| Yes, you will only need it in case you have to rollforward the
database pass the time of
the load. If you have a full offline backup after that, and never want
to restore an older version of the backup you don't need it.
/Lennart Quote:
Lennart pravi:
>
>
> Quote: |
On 7 Okt, 13:42, Gregor Kovaè <gregor.ko...@mikropis.siwrote: | > Quote: Quote:
If I do a LOAD .... COPY YES TO C:\DIR then in directory c:\DIR a file
is created. When can I delete that file?
| | > Quote:
You will need this file if you have to rollforward your database, thus
you should treat it as you do with your normal backup/logfiles. I'm
under the impression that it is acually a tablespace backup, but I
can't seem to find any references that support this assumption right
now.
| >> Quote: Quote:
Best regards,
* * * * Kovi
| | > Quote: Quote:
--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| *In A World Without Fences Who Needs Gates? * |
| * * * * * * *Experience Linux. * * * * * * * *|
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| | >
--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| *In A World Without Fences Who Needs Gates? * |
| * * * * * * *Experience Linux. * * * * * * * *|
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| |
October 9th, 2008, 06:25 AM
| | | Re: LOAD with COPY
Great, thanks.
Best regards,
Kovi
Lennart pravi: Quote:
On 8 Okt, 08:26, Gregor Kovač <gregor.ko...@mikropis.siwrote: Quote:
>OK, but if I do a full offline backup then I don't need the files
>anymore, right ?
>>
| >
Yes, you will only need it in case you have to rollforward the
database pass the time of
the load. If you have a full offline backup after that, and never want
to restore an older version of the backup you don't need it.
>
/Lennart
>
> Quote:
>Lennart pravi:
>>
>>
>> Quote:
>>On 7 Okt, 13:42, Gregor Kovaè <gregor.ko...@mikropis.siwrote:
>>>Hi!
>>>If I do a LOAD .... COPY YES TO C:\DIR then in directory c:\DIR a file
>>>is created. When can I delete that file?
>>You will need this file if you have to rollforward your database, thus
>>you should treat it as you do with your normal backup/logfiles. I'm
>>under the impression that it is acually a tablespace backup, but I
>>can't seem to find any references that support this assumption right
>>now.
>>/Lennart
>>>Best regards,
>>> Kovi
>>>--
>>>____________________________
>>>|http://kovica.blogspot.com|
>>>-----------------------------~-~-~-~-~-~-~-~-~-~-
>>>| In A World Without Fences Who Needs Gates? |
>>>| Experience Linux. |
>>>-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| >--
>____________________________
>|http://kovica.blogspot.com|
>-----------------------------~-~-~-~-~-~-~-~-~-~-
>| In A World Without Fences Who Needs Gates? |
>| Experience Linux. |
>-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| >
| --
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~- |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is Off | | |
| | | What is Bytes?
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over network members.
|
