Import fail in oracle 8i Err- Imp00037

Hi all of the Dearest Friends,

very urgently required ........ if possible

I am facing one problem in oracle 8i. When i am trying to import the database it's giving the err- IMP-00037 Character set marker unknown

i want to import my tables successfully. Any one there could help me in my problem.

@. specs about actions In detail...

I am trying to import the Tables from one oracle server to another oracle server. The Server from which i exported Tables having the database name PRJDB1 and the The server in which i am going to import has the name PRJDATA1.

so the question is can this create any problem?

or any other ideas/steps/helping hands on this.

Thankx in Advance.

JTP
Software EngineerYou can get this error if u are importing between different versions of oracle i.e. export from an 8.1.7 db then trying to import to a 8.1.6 db.

Are the version of oracle you using the same?

Import external data

Hi friends,
I want to import data from remote database(oracle) to my sql
server
local database.
As one of the group mate suggested I used Import(Tasks -> Import)
Its ok. But I want this to be done for a frequent of times and put in
a schedule. How can I do this.
And every time I import, the duplicates will not be imported I mean
the old data will not be imported again. ONly the current data to be
imported.
How can I make schedule and not alowing to import old records again?
Thanks in advanceMake a linked server and a stored procedure that pulls the data using a NOT
EXISTS clause. Then create an agent job on sql server to run it on whatever
schedule you desire. The same can probably be accomplished using SSIS as
well.
<mrajanikrishna@.gmail.com> wrote in message
news:1190732099.352879.45570@.y42g2000hsy.googlegroups.com...
> Hi friends,
> I want to import data from remote database(oracle) to my sql
> server
> local database.
>
> As one of the group mate suggested I used Import(Tasks -> Import)
> Its ok. But I want this to be done for a frequent of times and put in
> a schedule. How can I do this.
>
> And every time I import, the duplicates will not be imported I mean
> the old data will not be imported again. ONly the current data to be
> imported.
>
> How can I make schedule and not alowing to import old records again?
>
> Thanks in advance
>