Backup, Recover, Import, Export, Datapump, etc
pzuchelli
Rank: Programador Júnior
Posts: 27 Joined: Wed, 10 Jan 2007 8:29 pm
Location: SP
Fri, 30 Nov 2007 9:20 pm
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
Posts: 372 Joined: Tue, 24 Jan 2006 3:33 pm
Location: Palmas - TO
Contact:
Sun, 02 Dec 2007 9:19 pm
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
Posts: 16 Joined: Tue, 28 Jun 2005 11:39 am
Location: Pindamonhangaba - SP
Mon, 03 Dec 2007 3:14 pm
Dude,
Please post the command you are using, for example:
may be a matter of privileges, but I need to know What information you are putting on.
Doug
Rank: Programador Sênior
Posts: 49 Joined: Wed, 07 Feb 2007 1:08 pm
Location: São Paulo
Wed, 08 Dec 2010 10:32 am
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
Posts: 49 Joined: Wed, 07 Feb 2007 1:08 pm
Location: São Paulo
Wed, 08 Dec 2010 10:51 am
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
Users browsing this forum: No registered users and 19 guests