Home » RDBMS Server » Server Utilities » ORA-24372: invalid object for describe (oracle 10.2.0.1)
ORA-24372: invalid object for describe [message #429028] Sun, 01 November 2009 04:35 Go to next message
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
Re: ORA-24372: invalid object for describe [message #429033 is a reply to message #429028] Sun, 01 November 2009 06:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: ORA-24372: invalid object for describe [message #429035 is a reply to message #429028] Sun, 01 November 2009 06:55 Go to previous messageGo to next message
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.
Re: ORA-24372: invalid object for describe [message #429036 is a reply to message #429035] Sun, 01 November 2009 08:26 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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.
Re: ORA-24372: invalid object for describe [message #429039 is a reply to message #429035] Sun, 01 November 2009 08:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Copy and paste what you did and got.


Regards
Michel
Re: ORA-24372: invalid object for describe [message #429341 is a reply to message #429039] Tue, 03 November 2009 04:58 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
import success with warning


I am not able to see any warnings in your post....

Quote:
Michel Cadot

Quote:
Copy and paste what you did and got.


Regards
Michel



As suggested By Michel ...Please post What you did and what you got...and read the forum guide..before posting.

Thank you
Sriram.
Previous Topic: hot to copy all data to a new schema
Next Topic: Export of indexes fails
Goto Forum:
  


Current Time: Sun Dec 04 22:47:00 CST 2016

Total time taken to generate the page: 0.21574 seconds