Oracle logical backup

Backup, Recover, Import, Export, Datapump, etc
Post Reply
pzuchelli
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 27
Joined: Wed, 10 Jan 2007 8:29 pm
Location: SP

Good evening,

When I run a logical backup in Oracle, this error occurs:

Select all

. exporting context namespaces 
. exporting foreign function library names 
. exporting PUBLIC type synonyms 
EXP-00008: ORACLE error 904 encountered 
ORA-00904: : invalid identifier 
EXP-00000: Export terminated unsuccessfully
Someone can help. I already researched, but I did not find any solution. It seems not to be an invalid object.

Thanks.
gilbertoca
Rank: DBA Sênior
Rank: DBA Sênior
Posts: 372
Joined: Tue, 24 Jan 2006 3:33 pm
Location: Palmas - TO
Contact:

Select all

symptom: ORA-00904: Invalid column name 
symptom: EXP-00008: ORACLE error %s encountered 
[b]cause: The package is missing, invalid or corrupt[/b] 
Another thing, I have already found in other forums that this problem has solution through Metalink. Well, in this question I can not help because here we still do not support. : Cry:

Gilberto
cigano
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 16
Joined: Tue, 28 Jun 2005 11:39 am
Location: Pindamonhangaba - SP

Dude,

Please post the command you are using, for example:

Select all

exp user/pass
may be a matter of privileges, but I need to know What information you are putting on.
Doug
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 49
Joined: Wed, 07 Feb 2007 1:08 pm
Location: São Paulo

I have the same problem.

I tried to the EXP with the user system and the same error occurs.

Select all

exp system@msafdev file=system.dmp log=system.log buffer=30720
Doug
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 49
Joined: Wed, 07 Feb 2007 1:08 pm
Location: São Paulo

Select all

ORA-00904 - "POLTYP" : identificador invalido 
:(
Doug
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 49
Joined: Wed, 07 Feb 2007 1:08 pm
Location: São Paulo

I decided as follows.

On my server had 11g Database R1 installed and Client 11G R2.


Setie on path only R1 and EXP was successfully executed ..

I hope it helps ....

ABS
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 19 guests