Re: Restore Oracle 8i database

serge wrote:
> I apologize if I am not asking the right questions. I'll give it
> a final try, if my question is still unclear then ignore it.
>
> I don't know Oracle and I am actually the middle person here
> between the newsgroup and the person who is working with
> Oracle. The person who is trying to run the export is not familiar
> with the newsgroups so I am trying to understand her problem
> and post it here. I thought this process of exporting would be
> simple even for someone like me who doesn't know Oracle.
> Obviously i have failed as I am not communicating the real
> issue properly.
>
> I asked the person to have more info and this is what she
> provided me. If what she has given me is not enough
> information then I apologize in advance.
>
> I asked her to send me the message so I post it as is
> here, i hope it's clear what she is trying to do.
> What i understand is she is trying to export an 9i
> database using an 8i client but as you can see below,
> she is getting an error message. Does that error message
> indicate anything that she is doing wrong?
>
> "I tried to export data from 9i database using 8i
> (8.1.7.4.0.0) client, but I got that error.
> What can I do to fix it?
>
>
> Connected to: Oracle9i Enterprise Edition
> Release 9.2.0.1.0 - Production
> With the Partitioning, OLAP and Oracle Data
> Mining options
>
> JServer Release 9.2.0.1.0 - Production
> Enter array fetch buffer size: 4096 > 10028
>
> Export file: EXPDAT.DMP > c:\ABC_TEST.DMP
>
> (1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > u
>
> Export grants (yes/no): yes > y
> Export table data (yes/no): yes > y
> Compress exABCts (yes/no): yes > y
> Export done in WE8ISO8859P1 character set and UTF8 NCHAR character set
> server uses WE8MSWIN1252 character set (possible charset conversion)
> About to export specified users ...
> User to be exported: (RETURN to quit) > ABC899
> User to be exported: (RETURN to quit) >
>
> . exporting pre-schema procedural objects and actions
>
> . exporting foreign function library names for user ABC899
>
> . exporting object type definitions for user ABC899
>
> About to export ABC899's objects ...
>
> . exporting database links
>
> . exporting sequence numbers
>
> . exporting cluster definitions
>
> . about to export ABC899's tables via Conventional Path ...
>
> EXP-00008: ORACLE error 904 encountered
>
> ORA-00904: "SPOLICY": invalid identifier
>
> EXP-00000: Export terminated unsuccessfully"
>
>
> Now that i got this Oracle log result from her, i did my
> own search and found a lot of threads, including one that
> you're answering:
>
> http://groups-beta.google.com/group/comp.databases.oracle.server/browse_thread/thread/dd550d1467b8a192/a02da9683232933d?q=ORACLE+error+904+encountered&rnum=30#a02da9683232933d
>
> I will ask her to look into the posts in this Google search result
> and hopefully find the solution in one of the threads.
>
> http://groups-beta.google.com/groups?q=ORACLE+error+904+encountered
>
>
> Again, my apologies. I'll make sure I have a clear question
> and understanding of the issue before I post a question on
> behalf of someone else.
>
>
> Thank you for your time.
>
>
>
>

>>This isn't serious, isn't it? If you know how to run export, what you
>>have to do is obvious.
>>If you don't know export, you read up on it in the Oracle Server
>>Utilities Manual.
>>If you don't know about Oracle, you read about Oracle or stay away
>>from it, and hire a consultant.
>>
>>If you eat, you don't ask someone to chew your food, before you eat
>>it, don't you?
>>--
>>Sybrand Bakker, Senior Oracle DBA 

<HARSH RESPONSE>
Exporting is simple.

Learning to read documents is something that should have happened before graduating from primary school.

Tell your lazy friend to go to http://tahiti.oracle.com and read the docs.

A usenet group is not the place to provide training ... just help. </HARSH RESPONSE>

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)