Re: Restore Oracle 8i database

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
Received on Thu Jun 23 2005 - 16:54:20 CDT