Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
materialized view via link slow after upgrade from 8i to 9i

materialized view via link slow after upgrade from 8i to 9i

2005-11-04       - By Barbara Baker

Reply:     1     2     3     4     5  

I'm testing an upgrade of a database from version 8.1.7.4
<http://8.1.7.4>to version
9.2.0.4 <http://9.2.0.4>
Test db LEGS Oracle version 9.2.0.4 <http://9.2.0.4> just created
Prod db ARMS Oracle version 8.1.7.4 <http://8.1.7.4>
Prod db AMPROD Oracle version 9.2.0.4 <http://9.2.0.4>

Test (LEGS) is creating a materialized view via a link from the AMPROD
database.
This mview is created in less than 2 minutes when run from the prod ARMS 8i
database.
The same mview takes 40 minutes in the newly-upgraded test LEGS 9i database.

IDENTICAL MVIEW; only difference is running out of 8i database versus 9i
database.

All 3 databases are on the same VMS node. (OpenVMS 7.3-1)

Google/Metalink searches like "materialized view slow upgrade" yielded no
useful info.

The mview from the 8i database is gathering the data in a different manner.
For example, v8i:

SELECT "ACCT_NBR", . . . more stuff
FROM "ADMARC"."NAD" "NAD" WHERE "ACCT_NBR"=:1

call count cpu elapsed disk query rows
-- ---- -- --- -- ----- -- ---- -- -- ---- -- -- ---- -- -- ---- --
Parse 1 0.00 0.00 0 0 0
Execute 516 0.30 0.26 0 0 0
Fetch 516 0.18 0.65 73 2066 516
-- ---- -- --- -- ----- -- ---- -- -- ---- -- -- ---- -- -- ---- --
total 1033 0.48 0.92 73 2066 516


v9i: (I don't know what that sys_alias_1 thing is)

SELECT "ACCT_NBR, . . . more stuff
FROM "ADMARC"."NAD" "SYS_ALIAS_1"

call count cpu elapsed disk query rows
-- ---- -- --- -- ----- -- ---- -- -- ---- -- -- ---- -- -- ---
Parse 0 0.00 0.00 0 0 0
Execute 0 0.00 0.00 0 0 0
Fetch 8914 31.31 74.21 44894 63033 463481
-- ---- -- --- -- ----- -- ---- -- -- ---- -- -- --- -- ---- --
total 8914 31.31 74.21 44894 63033 463481


version 8i is doing this:

SELECT "ACCT_KEY","END_ISS","ACT_DATE" FROM
"ADMARC"."CNR" "CNR" WHERE "ACT_DATE">=TRUNC(:1-1) AND
"END_ISS">=TRUNC(:2-1)

call count cpu elapsed disk query rows
-- ---- -- --- -- ----- -- ---- -- -- ---- -- -- ---- -- -- ---- --
Parse 1 0.00 0.00 0 0 0
Execute 1 0.01 0.00 0 0 0
Fetch 1 13.04 24.60 17226 93473 547
-- ---- -- --- -- ----- -- ---- -- -- ---- -- -- ---- -- -- ---- --
total 3 13.05 24.61 17226 93473 547


version 9i is doing this:

SELECT "ACCT_NBR","ACT_DATE" FROM
"ADMARC"."NAD" "NAD" WHERE "ACCT_NBR"=:1 AND "ACT_DATE">=TRUNC(:2-1)

call count cpu elapsed disk query rows
-- ---- -- --- -- ----- -- ---- -- -- ---- -- -- ---- -- -- ---- --
Parse 0 0.00 0.00 0 0 0
Execute 463500 244.01 262.98 0 0 0
Fetch 463769 109.76 130.75 20767 1854059 269
-- ---- -- --- -- ----- -- ---- -- -- ---- -- -- ---- -- -- ---- --
total 927269 353.77 393.74 20767 1854059 269


9i is clearly choosing a different method, but I don't know why.

Here's the mview creation:

CREATE MATERIALIZED VIEW barb.MV_barb_CDT
TABLESPACE ARMS_DATA LOGGING BUILD IMMEDIATE
REFRESH FORCE ON DEMAND
AS
select * FROM admarc.nad@(protected)
where acct_nbr in
( select acct_nbr
from admarc.nad@(protected)
where act_date >= trunc(sysdate-1)
union select acct_key
from admarc.cnr@(protected)
where act_date >= trunc(sysdate-1)
and end_iss >= trunc(sysdate-1) )

I will be grateful for any ideas.
Thanks so much!
Barb

I'm testing an upgrade of a database from version <a href="http://8.1.7.4">8.1
.7.4</a> to version <a href="http://9.2.0.4">9.2.0.4</a><br>&nbsp;&nbsp;Test db
&nbsp;&nbsp;LEGS&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; Oracle version <a href="http:/
/9.2.0.4">9.2.0.4</a>&nbsp;&nbsp;just created
<br>&nbsp;&nbsp;Prod db&nbsp;&nbsp;ARMS&nbsp; &nbsp; &nbsp;&nbsp; Oracle
version <a href="http://8.1.7.4">8.1.7.4</a><br>&nbsp;&nbsp;Prod db&nbsp;&nbsp
;AMPROD&nbsp; Oracle version <a href="http://9.2.0.4">9.2.0.4</a><br><br>Test
(LEGS) is creating a materialized view via a link from the AMPROD database.&nbsp
;
<br>
This mview is created in less than 2 minutes when run from the prod ARMS 8i
database.&nbsp; <br>
The same mview takes 40 minutes in the newly-upgraded test LEGS 9i database.
&nbsp; <br>
IDENTICAL MVIEW; only difference is running out of 8i database versus 9i
database.<br><br>All 3 databases are on the same VMS node.&nbsp;&nbsp;(OpenVMS
7.3-1)<br><br>Google/Metalink searches like "materialized view slow upgrade"
yielded no useful info.
<br><br>The mview from the 8i database is gathering the data in a different
manner.&nbsp; <br>
For example, v8i:<br><br><span style="font-family: courier new,monospace;"
>SELECT &quot;ACCT_NBR&quot;, . . . more stuff</span><br style="font-family:
courier new,monospace;"><span style="font-family: courier new,monospace;">
FROM &quot;ADMARC&quot;.&quot;NAD&quot; &quot;NAD&quot; WHERE &quot;ACCT_NBR
&quot;=:1</span><br style="font-family: courier new,monospace;"><br style="font
-family: courier new,monospace;"><span style="font-family: courier new,monospace
;">
call&nbsp;&nbsp;&nbsp;&nbsp;
count&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
cpu&nbsp;&nbsp;&nbsp;&nbsp;elapsed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
disk&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;query&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;
rows</span><br style="font-family: courier new,monospace;"><span style="font
-family: courier new,monospace;">-- ---- -- ---&nbsp;&nbsp;-- ----- -- ---- -- -
-- ------ -- ---- --&nbsp;&nbsp; -- ---- --</span><br style="font-family:
courier new,monospace;">
<span style="font-family: courier new,monospace;">Parse&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0.00&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;
0.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0</span><br style="font-family: courier new
,monospace;"><span style="font-family: courier new,monospace;">Execute&nbsp;
&nbsp;&nbsp;&nbsp;516&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0.30&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;
0.26&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0</span><br style="font-family: courier new
,monospace;"><span style="font-family: courier new,monospace;">Fetch&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;516&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0.18&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;
0.65&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
73&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
2066&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;516</span><br style="font
-family: courier new,monospace;"><span style="font-family: courier new,monospace
;">-- ---- -- ---&nbsp;&nbsp;-- ----- -- ---- -- -- ---- -- -- ---- --&nbsp;
&nbsp; -- ---- --</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">total&nbsp;&nbsp;&nbsp;&nbsp;
1033&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0.48&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0.92&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
73&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
2066&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;516</span><br><br><br>v9i:
&nbsp;&nbsp;(I don't know what that sys_alias_1 thing is)<br><br>S<span style=
"font-family: courier new,monospace;">ELECT &quot;ACCT_NBR, . . .&nbsp;&nbsp
;more stuff</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">FROM &quot;ADMARC&quot;.&quot
;NAD&quot; &quot;SYS_ALIAS_1&quot;</span><br><br><span style="font-family:
courier new,monospace;">call&nbsp;&nbsp;&nbsp;&nbsp;
count&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
cpu&nbsp;&nbsp;&nbsp;&nbsp;elapsed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
disk&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;query&nbsp;&nbsp;&nbsp;&nbsp;rows</span
><br style="font-family: courier new,monospace;"><span style="font-family:
courier new,monospace;">-- ---- -- ---&nbsp;&nbsp;-- ----- -- ---- -- -- ------
- -- ---- --&nbsp;&nbsp;-- ---</span><br style="font-family: courier new
,monospace;">
<span style="font-family: courier new,monospace;">Parse&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0.00&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;
0.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;
0</span><br style="font-family: courier new,monospace;"><span style="font
-family: courier new,monospace;">Execute&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;
0</span><br style="font-family: courier new,monospace;"><span style="font
-family: courier new,monospace;">Fetch&nbsp;&nbsp;&nbsp;&nbsp;
8914&nbsp;&nbsp;&nbsp;&nbsp;
31.31&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;74.21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;44894&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;63033&nbsp;&nbsp;463481</span><br
style="font-family: courier new,monospace;"><span style="font-family: courier
new,monospace;">-- ---- -- ---&nbsp;&nbsp;-- ----- -- ---- -- -- ---- -- -- ---
&nbsp;&nbsp;-- ---- --</span>
<br style="font-family: courier new,monospace;"><span style="font-family:
courier new,monospace;">total&nbsp;&nbsp;&nbsp;&nbsp;
8914&nbsp;&nbsp;&nbsp;&nbsp;
31.31&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;74.21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;44894&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;63033&nbsp;&nbsp;463481</span><br
><br><br>version 8i is doing this:<br><br>SELECT &quot;ACCT_KEY&quot;,&quot;END
_ISS&quot;,&quot;ACT_DATE&quot; FROM<br> &quot;ADMARC&quot;.&quot;CNR&quot;
&quot;CNR&quot; WHERE &quot;ACT_DATE&quot;&gt;=TRUNC(:1-1) AND &quot;END_ISS
&quot;&gt;=TRUNC(:2-1)
<br><br><span style="font-family: courier new,monospace;">call&nbsp;&nbsp;&nbsp
;&nbsp;
count&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
cpu&nbsp;&nbsp;&nbsp;&nbsp;elapsed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
disk&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;query&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;
rows</span><br style="font-family: courier new,monospace;"><span style="font
-family: courier new,monospace;">-- ---- -- ---&nbsp;&nbsp;-- ----- -- ---- -- -
-- ------ -- ---- -- -- ---- --</span><br style="font-family: courier new
,monospace;">
<span style="font-family: courier new,monospace;">Parse&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0.00&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;
0.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0</span><br style="font-family: courier new
,monospace;"><span style="font-family: courier new,monospace;">Execute&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0.01&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
0.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0</span><br style="font-family: courier new
,monospace;"><span style="font-family: courier new,monospace;">Fetch&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;
13.04&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;24.60&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;17226&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;93473&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;547</span><br style="font-family: courier new,monospace;
"><span style="font-family: courier new,monospace;">-- ---- -- ---&nbsp;&nbsp;--
-- --- -- ---- -- -- ---- -- -- ---- -- -- ---- --
</span><br style="font-family: courier new,monospace;"><span style="font-family
: courier new,monospace;">total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3
&nbsp;&nbsp;&nbsp;&nbsp;
13.05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;24.61&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;17226&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;93473&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;547</span><br><br><br>version 9i is doing this:<br><br
>SELECT &quot;ACCT_NBR&quot;,&quot;ACT_DATE&quot; FROM<br> &quot;ADMARC&quot;.
&quot;NAD&quot; &quot;NAD&quot; WHERE &quot;ACCT_NBR&quot;=:1 AND &quot;ACT_DATE
&quot;&gt;=TRUNC(:2-1)
<br><br>c<span style="font-family: courier new,monospace;">all&nbsp;&nbsp;&nbsp
;&nbsp;
count&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
cpu&nbsp;&nbsp;&nbsp;&nbsp;elapsed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
disk&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;query&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;
rows</span><br style="font-family: courier new,monospace;"><span style="font
-family: courier new,monospace;">-- ---- -- ---&nbsp;&nbsp;-- ----- -- ---- -- -
-- ------ -- ---- -- -- ---- --</span><br style="font-family: courier new
,monospace;">
<span style="font-family: courier new,monospace;">Parse&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0.00&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;
0.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0</span><br style="font-family: courier new
,monospace;"><span style="font-family: courier new,monospace;">Execute
463500&nbsp;&nbsp;&nbsp;&nbsp;244.01&nbsp;&nbsp;&nbsp;&nbsp;
262.98&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0</span><br style="font-family: courier new
,monospace;"><span style="font-family: courier new,monospace;">Fetch&nbsp;&nbsp;
463769&nbsp;&nbsp;&nbsp;&nbsp;109.76&nbsp;&nbsp;&nbsp;&nbsp;
130.75&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20767&nbsp;&nbsp;&nbsp;&nbsp;1854059
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;269</span><br style="font-family
: courier new,monospace;"><span style="font-family: courier new,monospace;">----
--- -- ---&nbsp;&nbsp;-- ----- -- ---- -- -- ---- -- -- ---- -- -- ---- --</span
><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">total&nbsp;&nbsp;
927269&nbsp;&nbsp;&nbsp;&nbsp;353.77&nbsp;&nbsp;&nbsp;&nbsp;
393.74&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20767&nbsp;&nbsp;&nbsp;&nbsp;1854059
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;269</span><br>&nbsp;&nbsp;<br>
<br>9i is clearly choosing a different method, but I don't know why.<br><br>Here
's the mview creation:<br><br>CREATE MATERIALIZED VIEW barb.MV_barb_CDT<br
>TABLESPACE ARMS_DATA LOGGING BUILD IMMEDIATE
<br>REFRESH FORCE ON DEMAND<br>AS<br>select * FROM admarc.nad@(protected)<br>where
acct_nbr in<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;( select acct
_nbr<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;from admarc
.nad@(protected)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;where
&nbsp;&nbsp;act_date&nbsp;&nbsp;&gt;= trunc(sysdate-1)<br>&nbsp;&nbsp;&nbsp;
&nbsp;union select acct_key
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;from admarc.cnr
@(protected)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;where&nbsp;
&nbsp; act_date &gt;= trunc(sysdate-1)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;and&nbsp;&nbsp;&nbsp;&nbsp;
end_iss&nbsp;&nbsp;&gt;= trunc(sysdate-1) )<br><br>I will be grateful for any
ideas.<br>Thanks so much!<br>Barb<br>