Search results for query: *

Hi all, I'm a newbie to 9iAS, so bear with me. I have a simple J2EE app deployed. I would like to be able to type something simple to get to it, than the rather long and complicated address it has (machine/port/path). I also think I remember from the class something about hiding the physical...

Can anyone help with how to do the following in Oracle Warehouse Builder? I need to use the header record of a flat file and take a date value from it, and insert that date as a new field in the detail records during the mapping to the staging area. I have a field that identifies...

How do I identify a thread id for the snapshot refresh process in windows? 9i DB I need to kill it, but don't know how to identify the thread id. Thanks

Ho do I identify a thread id for the snapshot refresh process in windows? I need to kill it, but don't know how to identify the thread id. Thanks

What would be the recomended extent sizes for a data warehouse? I believe it's appropriate to have at least 2 standard sizes to accomodate large and small tables. I thought I read somewhere to use 160 Kb and 160 Mb. This is on W2K Server, 9i DB. Thanks.

I am upgrading to 9i, and intend on establishing a 9i instance on the same machine as 8i (windows 2k server). I planned on establishing the 9i instance and moving the data via transportable tablespaces, manually re-establishing the schemas, and replacing everything else with scripts. I want...

I have installed the 9i Enterprise software on myu server with the intention of creating a DB, and importing the data from my 8i db. I'm considering using Transportable Tablespaces for the move. Are there any adverse effects, or limitations I should be considering by using this method? Any...

I need to upgrade to 9i and am considering exactly how I want to upgrade. I'm tempted to set up a separate instance and re-create all my tablespaces, and then import the appropriate schemas. This way I don't get all the crap that has seemed to accumulate in the DB via installing various...

I have a partitioned table that is defined as being in a tablespace, but composed of partitions in other tablespaces. How can I export it using Transportable tablespaces? Script follows. CREATE TABLE T_CUSTOMER_TA_ARC ( ACCOUNT_NUMBER VARCHAR2(8) NOT NULL, TA_NUMBER NUMBER(5) NOT NULL...

I don't seem to have the package DBMS_TTS in my 8.17 DB. How do I install it? Thanks

I have an exchange link to the Global address List, which I have designed a schema.ini file so that I can retrieve values in custom exchange fields. It works fine if I put the schema.ini file in my temp folder, because that is where Access points the DATABASE parameter to. However, this is a...

We are in a position to purchase either Oracle 9i or SQL Server 2000 for a small data warehouse. We currently have an Oracle 8i DB, but have to re-purchase a lisence (long story). Aside from the massive price differences, can anyone provide any technological reasons why to select one over the...

I have a view which utilized 2 inline views as part of the FROM clause. A simplified example: Select <fields> FROM table1 ,(select <fields> from table2) t2 ,(select <fields> from table3) t3 WHERE t1.account_number = t2.account_number and t2.account_number = t3.account_number (+) and...

Does anyone know a simple way to determine what dates are missing, given a table with dates in it? For example, I have a table which gets populated with historical data, and I want to find out if any dates are missing. Thanks

Here's my insert trigger: CREATE OR REPLACE TRIGGER TG_MONEY_BAL_ARC_INS BEFORE INSERT ON T_MONEY_BAL_ARC FOR EACH ROW DECLARE tmpVar DATE; tmpVar2 number; BEGIN tmpVar := NULL; if NVL(:OLD.RECORD_DATE,SYSDATE) > TRUNC(SYSDATE) THEN Select HEADER_DATE into tmpVar FROM...

Just got off the phone with my Oracle sales rep, and I cannot believe what he is telling me, and am hoping for some veriication. He tells me that if I have a standby database that it must be separately licensed. Meaning that if you have a single DB, using a standby DB for disaster recovery or...

Does anyone know how to format a column in a pass through query? I am using a pass through to Oracle, and numeric fields are being returned as text in the query result window. I have tried multiplying the field by 1, and using the to_number oracle function on the field in the SQL. Nothing...

I have inconsistent query results from a sybase DB when queried from ORacle via odbc using HS Services. Joins work inconsistently, date fields need native Sybase format, forced to use 'Distinct' on some queries. Odd behavior. Running 8.17 on W2K. Is anyone using GC/HS to connect Ora to...

I'm experimenting with a CLOB column. Notes I've found indicate the actual CLOB is stored in 'OS files' and that just a pointer is stored in the actual table, if it's over 4000 bytes. Where does the DB store these files, and what are they called? I loaded the table via SQLLDR. Thanks

Does anyone know where I can download the Transparent Gateway for Sybase for NT install for Oracle 8i? I need to try this out before we buy, and I don't know if I can buy for 8i anymore.