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...

you can fget the behavior you want by making the criteria for b something like (b = 1 or b is null)

I looked into this a while ago as well. Some features that I would have significantly missed from Oracle (I run a data warehouse) is Bitmap indexes, true partitioning (huge !!!), function based indexes (SQL Serve has derived fields for this, but requires a table change, and new index to mimick...

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...

Are you using transportable tablespaces to move the data?

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...

Also, If you let your support contract lapse, and you later want to have support, you will have to back pay all support, and possible migrate to whatever the current licensing is. We are experiencing this now and it SUCKS!!!! We had a concurrent Session license from 1998, and now have to...

make a union query. Select results from t1 union all select results from t2 etc.

Access will provide the full width of the field (at least if the Oracle datatypes map nicely to the Access types). Too bad you don't have. Sometimes it can make for simple solutions.

you can link the table via ODBC to ACCESS and use it's export feature using fixed width style to accomplish this.

yes, good points. I've been bitten by each a few times.