OraFAQ Forum: Server Administration » Audit & Trace Database Changes

Home » RDBMS Server » Server Administration » Audit & Trace Database Changes

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

Audit & Trace Database Changes [message #304336]

Tue, 04 March 2008 22:46

irfan.ocp
Messages: 29
Registered: February 2008
Location: Karachi, Pakistan

Junior Member

04 March, 2008

Dear All

I have 2 Tablespace on my OS. One SID is "GREEN" and other "GREY". On both SID i had created a same name user 'AUDIT'

I want to check that what is difference between this two users. what columns are different, Column Type, Views, Procedure, Function and so on.

Is there any way which help me out to solve my problem.

Thanks

Best Regards,
Muhammad Irfan Bakali.

Report message to a moderator

Re: Audit & Trace Database Changes [message #304349 is a reply to message #304336]

Tue, 04 March 2008 23:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>On both SID i had created a same name user 'AUDIT'

Creating schema with the same name as an Oracle Reserved Word is a BAD idea & borderline foolish implementation.

>I want to check that what is difference between this two users.
It appears that both the search function on this forum & GOOGLE is broken for you. Too bad for you.
Please sit back & wait for a clue to introduce itself to you.

Report message to a moderator

Re: Audit & Trace Database Changes [message #304370 is a reply to message #304336]

Wed, 05 March 2008 00:30

mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai

Member

Quote:

I have 2 Tablespace on my OS.

Any OS having Tablespaces ?

Quote:

One SID is "GREEN" and other "GREY".

Any tablespace have SID in Oracle ?

Quote:

On both SID i had created a same name user 'AUDIT'

I would be nice if you use oracle terminology of databases,instances & schema e.t.c. It would indeed help forum members to understand your situation in a better way.

Regards

Report message to a moderator

Re: Audit & Trace Database Changes [message #304381 is a reply to message #304336]

Wed, 05 March 2008 00:46

irfan.ocp
Messages: 29
Registered: February 2008
Location: Karachi, Pakistan

Junior Member

Thanks friend for giving me reply.

Let me Clear you out.

in my OS i have 2 Databases

1. GREEN
in GREEN i have USER 'AUDIT'

2. GREY
in GREY i have USER 'AUDIT'

basically i want to know the different b/w GREEN.AUDIT.TABLES/COLUMNS and GREY.AUDIT.TABLES/COLUMNS

Best Regards,
Muhammad Irfan Bakali

[Updated on: Wed, 05 March 2008 00:48]

Report message to a moderator

Re: Audit & Trace Database Changes [message #304389 is a reply to message #304336]

Wed, 05 March 2008 01:03

mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai

Member

If you have TOAD than your comparision becomes easier else you can try following Link
http://www.codeproject.com/KB/database/OracleSchemaCompare.aspx

Regards

Manjit Kumar[mkbhati]

Report message to a moderator

Re: Audit & Trace Database Changes [message #304395 is a reply to message #304336]

Wed, 05 March 2008 01:08

mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai

Member

A few more for your reference

- Try OEM
- http://www.dbspecialists.com/scripts.html
- http://www.softtreetech.com/dbtools/
- http://www.impacttoys.com/download.htm
- http://www.dbsolo.com/schema_comparison.html
- http://www.dkgas.com/oradiff_screens.htm

Regards

Manjit Kumar [mkbhati]

Report message to a moderator

Re: Audit & Trace Database Changes [message #304399 is a reply to message #304336]

Wed, 05 March 2008 01:13

irfan.ocp
Messages: 29
Registered: February 2008
Location: Karachi, Pakistan

Junior Member

Dear Manjit Kumar

Many thanks for this Link. Thats i want it. Its a PreCompiled Software. i help me out no doubt. but can you tell/share the logic use behind this. mean what the logic he used to compare schema. Smile

Best Regards,
Muhammad Irfan Bakali

Report message to a moderator

Re: Audit & Trace Database Changes [message #304402 is a reply to message #304336]

Wed, 05 March 2008 01:21

mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai

Member

Quote:

can you tell/share the logic use behind this. mean what the logic he used to compare schema.

Nothing complex you can do it yourself in PLSQL just retrieve objects in a schema one by one in a loop and store their attributes in variables & compare them and output suitable messages accordingly. Try this as a project for yourself if you have time..... I may wish you good luck in advance.

Regards

Manjit Kumar [mkbhati]

Report message to a moderator

Re: Audit & Trace Database Changes [message #304404 is a reply to message #304336]

Wed, 05 March 2008 01:22

irfan.ocp
Messages: 29
Registered: February 2008
Location: Karachi, Pakistan

Junior Member

Dear Manjit Kumar

Good Boss. Thanks Smile

Best Regards,
Muhammad Irfan Bakali

Report message to a moderator

Previous Topic:	READ ONLY Tablespace - Free Space
Next Topic:	Indexes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 18 23:17:53 CDT 2024