Oracle Database Discussions

Hello,

I'm working on a project which need an import of a database from oracle 8i.
I have a previous version of an import to work in this copy for the moment. Import was made via microsoft access, but no dependencies with it. So i search them on the original database, and I found that in my import there was missing the master table.
So i attempt to import the table again via access, but an error happens saying that my data are not in the right type. A little search and i found a entry where all fields contain "#ERROR".
Thinking that's weird, i connect sql developer (1.1 for more compatibility with 8i) to the original database, but this entry with errors doesn't appear. So another attempt to import via sql developer (Tools > Export DDL (and Data)).
It says a first error: ORA-00942 table or view doesn't exist.
Then 8 other errors saying DBMS_METADATA.SESSION_TRANSFORM must be declared for several lines.
So now I don't try anymore import, and i copied source files of my database into my work computer (.dbf and .ctl files). Now I hope to connect this files on a 10g or 11g virtual machine. Is it possible?

Another thing, I tried to view my files with dbf viewer but it says "table header is invalid".

If anyone can help me, it will be great.
Thank you


P.S: if my english is not correct, say me (a french guy)

Edited by: user13381379 on 13 juil. 2010 07:11

Edited by: user13381379 on 13 juil. 2010 07:12