OraFAQ Forum: Server Administration » Not able to Query user

Home » RDBMS Server » Server Administration » Not able to Query user_jobs. (HP-UX 10g)

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

Not able to Query user_jobs. [message #474452]

Mon, 06 September 2010 09:37

madhavamanohar
Messages: 58
Registered: February 2009

Member

Dear Team,

Recently we have refreshed one schema using datapump.

we have one table called user_jobs in Schema1 and its not showing in DBA_TABLES for that schema, when I connect to that schema its showing records in that schema.

SQL> show user
USER is "schema1"
SQL> select counT(*) from user_jobs;

COUNT(*)
----------
18

same has been refreshed to schema2

SQL> show user
USER is "schema2"
SQL> select counT(*) from user_jobs;

COUNT(*)
----------
0

Please help me

Thanks Manohar.

Report message to a moderator

Re: Not able to Query user_jobs. [message #474454 is a reply to message #474452]

Mon, 06 September 2010 09:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> select owner, object_type from dba_objects where object_name = 'USER_JOBS';

OWNER			       OBJECT_TYPE
------------------------------ -------------------
SYS			       VIEW
PUBLIC			       SYNONYM

perhaps you should NOT use object name that conflicts with existing SYS object?

Report message to a moderator

Re: Not able to Query user_jobs. [message #474455 is a reply to message #474452]

Mon, 06 September 2010 09:42

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

we have one table called user_jobs in Schema1 and its not showing in DBA_TABLES for that schema

Prove it!
It is a bad idea to create a table with the same name than a standard view.

Quote:

same has been refreshed to schema2

Prove it!

Copy and paste what you did, ALL what you did.

Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator

Re: Not able to Query user_jobs. [message #474457 is a reply to message #474455]

Mon, 06 September 2010 10:12

madhavamanohar
Messages: 58
Registered: February 2009

Member

Can you please clarify me one thing...Suppose If I have not schedule any jobs at db level the view USER_JOBS will give any rows?

Thanks Manohar

Report message to a moderator

Re: Not able to Query user_jobs. [message #474458 is a reply to message #474457]

Mon, 06 September 2010 10:20

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

User_jobs shows jobs that belong to current user. So if you don't have any querying that view will give no rows obviously.

Report message to a moderator

Re: Not able to Query user_jobs. [message #474459 is a reply to message #474458]

Mon, 06 September 2010 10:25

madhavamanohar
Messages: 58
Registered: February 2009

Member

Thank You.

I got the solution..

Laughing

Can you please share syntax of how to create a job by every 15 mins.

Thanks Manohar.

Report message to a moderator

Re: Not able to Query user_jobs. [message #474461 is a reply to message #474459]

Mon, 06 September 2010 10:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Can you please share syntax of how to create a job by every 15 mins.
CREATE job every 15 minutes
or
RUN job every 15 minutes?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator