|
Replies:
1
-
Pages:
1
-
Last Post:
Aug 3, 2010 11:47 AM
by: John Dorlon
|
|
|
|
|
|
|
single object compare bug
Posted:
Jul 29, 2010 8:09 AM
|
|
|
|
|
Getting ORA-00903: invalid table name when trying to selecting a "schema" for
"Live schema" in "Single Schema Object Compare"
SQL underneath:
select distinct decode( object_type , 'JOB' , 'SCHEDULER JOB' , object_type )
object_type from DBA_OBJECTS where owner = 'TRAFFIC' and object_type not like
'%PARTITION%' and object_type not like 'LOB%' and object_type 'TYPE BODY'
Union
select 'MATERIALIZED VIEW' from DBA_SNAPSHOTS where owner = 'TRAFFIC' and rownum
= 1
union all
select 'MATERIALIZED VIEW LOG' from DBA_SNAPSHOT_LOGS where log_owner =
'TRAFFIC' and rownum = 1
union all
select 'REFRESH GROUP' from DBA_REFRESH where rowner = 'TRAFFIC' and rownum = 1
union all
select 'JOB' from DBA_JOBS where log_user = 'TRAFFIC' and rownum = 1
union all
select 'QUEUE TABLE' from DBA_QUEUE_TABLES where owner = 'TRAFFIC' and rownum =
1
union all
select 'CONTEXT' from DBA_CONTEXT where schema = 'TRAFFIC' and rownum = 1
union all
select 'POLICY' from DBA_POLICIES where object_owner = 'TRAFFIC' and rownum = 1
union all
select 'POLICY GROUP' from DBA_POLICY_GROUPS where object_owner = 'TRAFFIC' and
rownum = 1
union all
select 'TRANSFORMATION' from sys . where owner = 'TRAFFIC' and rownum = 1
Yoni
This is an object-oriented system. If we change anything, the users object.
powered by pelephone
|
|
|
|
|
|
|
RE: single object compare bug
Posted:
Aug 3, 2010 11:47 AM
in response to: Sade Yoni
|
|
|
|
|
Thanks, this will be fixed next beta.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
