OraFAQ Forum: Server Utilities » ORA-24372: invalid object for describe

Home » RDBMS Server » Server Utilities » ORA-24372: invalid object for describe (oracle 10.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-24372: invalid object for describe [message #429028]

Sun, 01 November 2009 04:35

goracle9
Messages: 136
Registered: December 2006

Senior Member

morning i import 2 schema object into one schema
when i desc objects, it saying error like

ORA-24372: invalid object for describe

please give me solution

Report message to a moderator

Re: ORA-24372: invalid object for describe [message #429033 is a reply to message #429028]

Sun, 01 November 2009 06:11

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Copy and paste what you did and got.
Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.

Regards
Michel

Report message to a moderator

Re: ORA-24372: invalid object for describe [message #429035 is a reply to message #429028]

Sun, 01 November 2009 06:55

goracle9
Messages: 136
Registered: December 2006

Senior Member

we have oracle database server 10.2.0.1 OS Redhot linux 4
we have 2 schemas parts,service
developer required to create new schema namly sales and import existing schema parts & service object into sales(no data rows=n)

i created seperate table space for sales and create user sales
import parts object first next service object

imp parfile=impschema.par

impschema.par

userid=system/develop
fromuser=parts
touser=sales
rows=n
grants=y
indexes=y
file=/home/exp.dmp
log=/home/nov1.log

import success with warning

userid=system/develop
fromuser=service
touser=sales
rows=n
grants=y
indexes=y
file=/home/exp.dmp
log=/home/nov1.log

import success with warning

connect sales/sales@ora
connected.
select tname from tab;

it listed the object list. when i DESC some of object described
some other giving error like

ORA-24372: invalid object for describe

reply plz.

Report message to a moderator

Re: ORA-24372: invalid object for describe [message #429036 is a reply to message #429035]

Sun, 01 November 2009 08:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

24372, 00000, "invalid object for describe"
// *Cause:  The object to be described is not valid.
//          It either has compilation or authorization errors.
// *Action: The object to be described must be valid.

Report message to a moderator