Home » Other » General » INVALID OBJECTS
INVALID OBJECTS [message #306588] Fri, 14 March 2008 15:48 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

hi,

we run the check list script to compile the INVALID OBJECTS and initrans in the table from a particular schema in the primary database and so on...

i just want to know what is INVALID object mean??

Regards
Balaji
Re: INVALID OBJECTS [message #306591 is a reply to message #306588] Fri, 14 March 2008 17:25 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
What do you think that it means balaji? Where do you think you should look to try to find this info? Put some effort in and others will help you, put no effort in and they are less likely to help.
Re: INVALID OBJECTS [message #306593 is a reply to message #306588] Fri, 14 March 2008 17:47 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member



im an junior DBA and i cannot ask this type of question to my seniors.so all that i want to say is help me if u can.

Re: INVALID OBJECTS [message #306594 is a reply to message #306593] Fri, 14 March 2008 18:42 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Putting "INVALID OBJECTS oracle" into Google brings back 135,000 hits.
Re: INVALID OBJECTS [message #306595 is a reply to message #306588] Fri, 14 March 2008 18:58 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Mar 14 18:21:48 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select status, count(*) from dba_objects group by status;

STATUS    COUNT(*)
------- ----------
INVALID          1
VALID        68591


>i just want to know what is INVALID object mean??
It means the object has a status of "INVALID".

[Updated on: Fri, 14 March 2008 20:24] by Moderator

Report message to a moderator

Re: INVALID OBJECTS [message #306619 is a reply to message #306595] Sat, 15 March 2008 02:13 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you don't know what INVALID means, try to create (on purpose) an invalid procedure and execute it. For example
SQL> create procedure prc_invalid as
  2  begin
  3    select 'x' from dual;
  4  end;
  5  /

Warning: Procedure created with compilation errors.

SQL> exec prc_invalid;
BEGIN prc_invalid; END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00905: object SCOTT.PRC_INVALID is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


SQL>

Or, do something similar with a synonym:
SQL> create table tab_invalid (abc number);

Table created.

SQL> create synonym syn_invalid for tab_invalid;

Synonym created.

SQL> drop table tab_invalid;

Table dropped.

SQL> select * From syn_invalid;
select * From syn_invalid
              *
ERROR at line 1:
ORA-00980: synonym translation is no longer valid


SQL>

Did you now get the idea of what INVALID means? Simply - you can't use something that isn't valid.

Also, I'm very sorry your seniors are all dragons (or sharks, bugbears, or other similar creatures) so that you are unable to ask any question you want. Just make sure to grow up into a scary creature yourself; it would be a shame if you couldn't scare juniors some day.
Re: INVALID OBJECTS [message #306651 is a reply to message #306588] Sat, 15 March 2008 09:28 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

but certain things cannot be shared with others like seniors .
Re: INVALID OBJECTS [message #306658 is a reply to message #306651] Sat, 15 March 2008 10:25 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
balaji1482 wrote on Sat, 15 March 2008 15:28
but certain things cannot be shared with others like seniors .

Oh yes, they can.
Unless you were hired on the wrong grounds, for instance you claiming to have a level of knowledge/experience that you don't actually have. Or by memorizing so-called interview questions and then bumping into an ignorant interviewer.
If either of the above is true, you have only yourself to blame. If you are hired as the junior you seem to be, then you should not be afraid or ashamed to ask anything. I for me rather see my juniors asking questions they might think of as stupid, then no questions at all!
Re: INVALID OBJECTS [message #307014 is a reply to message #306588] Mon, 17 March 2008 09:29 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

for some questions they answer and for some questions they ask me to study by own which i feel difficult to understand.
Re: INVALID OBJECTS [message #307022 is a reply to message #307014] Mon, 17 March 2008 10:04 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
And when they tell you to go study it yourself, you turn to us.
That's not the way to learn. They mean you should study the documentation, try to find the answer by yourself, as this is a very very important part of your (future) work!
Re: INVALID OBJECTS [message #307029 is a reply to message #307022] Mon, 17 March 2008 11:00 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Reminds me of a poem I recently read:

Parasiting  
I want a position I said I could do
      But haven't experience to back what I knew
So I post in the forum -  my defacto mentor
     Brain dump your knowledge to this genus stentor
I need it right now, it's an URGENT request!
  	You've done it all, what would you suggest?
'RTFM', I think not my DEAR friend
  	I just asked for the steps, beginning to end.

       				--Author dbtoo
Re: INVALID OBJECTS [message #307046 is a reply to message #307029] Mon, 17 March 2008 13:05 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Painfully true!
Re: INVALID OBJECTS [message #307875 is a reply to message #307029] Thu, 20 March 2008 04:04 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

i think u could become an best poetry author instead of helping others in online/offline queries.
because nowadays we feel less number of poetries in the world.
Re: INVALID OBJECTS [message #307876 is a reply to message #307046] Thu, 20 March 2008 04:05 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

and you can be his helper instead.

[Updated on: Thu, 20 March 2008 04:06]

Report message to a moderator

Re: INVALID OBJECTS [message #307898 is a reply to message #307875] Thu, 20 March 2008 05:16 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
balaji1482 wrote on Thu, 20 March 2008 09:04
i think u could become an best poetry author instead of helping others in online/offline queries.
because nowadays we feel less number of poetries in the world.


ebrian clearly states that he recently read the poem. He makes no implication that he wrote it. The point of the poem was to basically recognize that you fall into the category of people who have gained employment by lying about your knowledge and abilities and you now expect others to do your work for you because you are unwilling, or more likely, unable to do the work for yourself. The definition of what an invalid object IS and when objects can become INVALIDATED is easily obtainable by simply reading the documentation. You have shown, time and again, on this forum, that you are unwilling to put any effort in and that you expect to be spoon fed information on whatever topic you are incapable of reading about on any given day. Personally, I think that you are in the wrong job if you are unable to read the manual, maybe it is you who should turn to poetry (but let's face it, you'd just end up on another forum asking for words that rhyme with lakh, or glee or some such).
Note, this is a personal observation and does not (necessarily) reflect the views of others on this forum.
Re: INVALID OBJECTS [message #308127 is a reply to message #307029] Fri, 21 March 2008 06:19 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at the following: http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=32431&SkipA=0 from someone posting here under the name "oracle_coorgi".

You thought they just want the solution, now they also think they don't have to give the question (at least the post is formatted Wink ).

Regards
Michel
Previous Topic: Does any one know about Core Banking Environments??
Next Topic: BI then ERP Strategy
Goto Forum:
  


Current Time: Thu Dec 08 02:28:54 CST 2016

Total time taken to generate the page: 0.11311 seconds