Home » RDBMS Server » Server Administration » Audit & Trace Database Changes
Audit & Trace Database Changes [message #304336] Tue, 04 March 2008 22:46 Go to next message
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.
Re: Audit & Trace Database Changes [message #304349 is a reply to message #304336] Tue, 04 March 2008 23:53 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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.
Re: Audit & Trace Database Changes [message #304370 is a reply to message #304336] Wed, 05 March 2008 00:30 Go to previous messageGo to next message
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
Re: Audit & Trace Database Changes [message #304381 is a reply to message #304336] Wed, 05 March 2008 00:46 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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]
Re: Audit & Trace Database Changes [message #304395 is a reply to message #304336] Wed, 05 March 2008 01:08 Go to previous messageGo to next message
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]

Re: Audit & Trace Database Changes [message #304399 is a reply to message #304336] Wed, 05 March 2008 01:13 Go to previous messageGo to next message
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
Re: Audit & Trace Database Changes [message #304402 is a reply to message #304336] Wed, 05 March 2008 01:21 Go to previous messageGo to next message
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]
Re: Audit & Trace Database Changes [message #304404 is a reply to message #304336] Wed, 05 March 2008 01:22 Go to previous message
irfan.ocp
Messages: 29
Registered: February 2008
Location: Karachi, Pakistan
Junior Member
Dear Manjit Kumar

Good Boss. Thanks Smile

Best Regards,
Muhammad Irfan Bakali
Previous Topic: READ ONLY Tablespace - Free Space
Next Topic: Indexes
Goto Forum:
  


Current Time: Sun Dec 04 18:36:37 CST 2016

Total time taken to generate the page: 0.13175 seconds