OWB : how to share directories between production and test.

From: steen bartholdy <steenbdkoraclel_at_yahoo.dk>
Date: Wed, 14 Dec 2005 11:29:15 +0100 (CET)
Message-ID: <20051214102915.15777.qmail@web26014.mail.ukl.yahoo.com>

Hi
OWB 9.2.0.8
database 9207
windows environment  

production :
We want g: refer to a local drive
test :
g: refers to the same data as g: on production. But we are getting
>>

SQL> select * from dba_directories where DIRECTORY_NAME = 'STB_S_PERS';

OWNER                          DIRECTORY_NAME
------------------------------ ------------------------------

DIRECTORY_PATH

---

SYS                            STB_S_PERS

O:\data\pers\dimension\
  SQL> select count(*) from s_pers.stb_d_omkost_et; select count(*) from s_pers.stb_d_omkost_et *
ERROR at line 1:

ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file omkost_d.csv in STB_S_PERS not found
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1

  SQL> CREATE OR REPLACE DIRECTORY STB_S_PERS   2 as 'w:\dmimport\data\pers\dimension\'; Directory created.
SQL> select count(*) from s_pers.stb_d_omkost_et;   COUNT(*)

---

       126
SQL> select * from dba_directories where DIRECTORY_NAME = 'STB_S_PERS';

OWNER                          DIRECTORY_NAME
------------------------------ ------------------------------

DIRECTORY_PATH

---

SYS                            STB_S_PERS

w:\dmimport\data\pers\dimension\
  SQL>
<<
locally :
>>

O:\>dir O:\data\pers\dimension\omkost_d.csv  Volume in drive O is scripts
 Volume Serial Number is 14AF-7BCE
 Directory of O:\data\pers\dimension

14-10-2005  09:38               10.902 omkost_d.csv
               1 File(s)         10.902 bytes
               0 Dir(s)  26.503.692.288 bytes free

O:\>dir w:\dmimport\data\pers\dimension\omkost_d.csv  Volume in drive W is scripts
 Volume Serial Number is 14AF-7BCE
 Directory of w:\dmimport\data\pers\dimension

14-10-2005  09:38               10.902 omkost_d.csv
               1 File(s)         10.902 bytes
               0 Dir(s)  26.503.651.328 bytes free

O:\>
<<
  So even a driveletter that is created with subst doesnt work on local server. Should we try a different approach to sharing data between production and test or is this possible ? Kind regards
Steen B

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 14 2005 - 04:29:48 CST