Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Q: Export without any Table Data...why?

Re: Q: Export without any Table Data...why?

From: Ralf Bender <ralf.bender_at_arcor.de>
Date: Fri, 13 May 2005 14:14:06 +0200
Message-ID: <42849a0b$0$25675$9b4e6d93@newsread2.arcor-online.net>


Rauf Sarwar said the following on 12.05.2005 17:10:
> Ralf Bender wrote:
>

>>Hello,
>>
>>something strange happens here and I don't know why:
>>
>>I want to export a Oracle 8.1 Database as I do often from another pc

>
> in
>
>>the network.
>>Starting the export with user SYSTEM, Oracle starts to export all,

>
> but
>
>>without any Tabledata?
>>What's going wrong here? User SYSTEM got the role EXP_FULL_DATABASE.
>>
>>This is my export command:
>>exp userid=system/manager_at_database full=y compress=n log=exp.log
>>file=full.dmp
>>
>>thanks
>>ralf

>
>
> 1) Have you actually verified this information after doing the full
> import *without* rows=n switch?
> 2) Have you tried adding rows=y switch in both exp/imp commands?
> Although it's set to y by default but no harm if you do specify it.
>
> Regards
> /Rauf
>

I extra specify rows=y , but no table data would be exported.

I got my information that there are no data only from the log. I didn't import the exported data. And I can't do this at the moment, because the database is a very big one. I want the export for backup...

regards
ralf Received on Fri May 13 2005 - 07:14:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US