Software

Thanks for your kind help.

Whenever I try this command:

I>imp userid=technos/technos file=noic.dmp log=extract_noic full=y toid_novalidate=naventry_ty

I get the following error:

Export file created by EXPORT:V08.01.07 via conventional path
Warning: the objects were exported by TECHNOS, not by you

I don't know how to create the TECHNOS

The problem here is, I need to create an Oracle account called TECHNOS with CONNECT, UNLIMITED quota on target tablespace, and IMP_FULL_DATABASE system privileges. And I don't know what to do.

Please help! I'm running Windows 2003 with Oracle 8i Enterprise Server installed, it's a new/clean installation. Do I need Oracle 8i Client softwares too?

Please help me creating the TECHNOS

<TIA>

was the server admin login for the oracle server the db was created on.

run the server admin app, set up a second admin account called TECHNOS

you will need the client software to acess the database, but not to import it, if you can setup and login under an account with same name as original.

or, open the .dmp with wordpad, it should be a plain text or rich text file, despite the .dmp extention.
edit the created by name to match your admin login.
remove password data and replace with proper password if needed.

Thanks Jaqui

Password and everything else went fine. But now I'm getting this error ISO error!!!

ISO Error:

Export file created by EXPORT:V08.01.07 via conventional path
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
IMP-00069: Could not convert to environment national character set's handle
IMP-00000: Import terminated unsuccessfully

I guess it would be the last step.

TIA

it's a charset issue.
iso8859-1 is default western europe language encoding.
hense the WE8 ISO8859P1
you have an extra charset, the iso8859-1 NCHAR showing for some reason.

Any workarounds to get things go smoothly?

TIA