Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Beantree

  1. Beantree

    newbie - hide actual address of j2EE app

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

    How to Handle Header record date for flat file - OWB

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

    Outer Join with condition doesn't work

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

    Oracle vs. SQL Server, et. al.

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

    How to identify thread for snapshot refresh in windows

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

    How to identify thread for snapshot refresh in windows

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

    recomended extent sizes

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

    2 instances, same machine

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

    migrate to 9i using TTS

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

    Upgrading to 9i

    Are you using transportable tablespaces to move the data?
  11. Beantree

    Upgrading to 9i

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

    Partitioned table TTS export

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

    DBMS_TTS install

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

    specify location of schema.ini for Exchange link

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

    opinions on Oracle 9i Vs SQL Server 2000

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

Part and Inventory Search

Back
Top