nt/2000 oracle experience to install on linux
Laura55, actually it is more complex installing Oracle on Windows. The main things you want to consider is the placement of your datafiles and configure the memory for use. There are a lot of good places to find reference material, but if you can’t find any that are suitable, just email me and I can [...]

View Answer   |  May 12, 2004  3:35 PM
Linux, Oracle

Encryption in the Database
Yes, in a ASP.Net application we encrypted CC info as the SQL server was located at a site we did not control. It was very straightforward to code (VB.net). We did not performance track it as we were only reading/writing one record at a time but I would think it would be minimal.

View Answer   |  May 12, 2004  2:31 PM
Oracle, OS/390, SQL Server, UDB for mainframe, z/OS

upgrade to 10g
I just migrated a production 9.0.1 DW instance to 10g on Suse Linux. I had some problems with the upgrade and I ended up doing a transportable tablespace from 9i to 10g. It was a little odd way of doing the migration but it worked.

View Answer   |  May 12, 2004  1:44 PM
Oracle 10g

Oracle storage parameters – next extent size and max extents
You did not indicate Oracle version. If 8i or higher, you should be using LMTs (locally managed tablespaces) and stop worrying about next extent sizes and max extents. Group tables by function and average size and set up locally managed tablespaces with uniform extent size (in 8i) for small, medium and large. Put the tables [...]

View Answer   |  May 12, 2004  1:42 PM
Oracle

Oracle 10g ASM
Yes you can. I am not sure why you would want to do this. An ASM instance can not serve as an actual DB instance. It only serves up diskgroups to the real db’s. The way to setup an ASM db is using the following initASM.ora. INSTANCE_TYPE=ASM ASM_DISKGROUPS =’dgroup1′ ASM_DISKSTRING =’/dev/raw/*’ shared_pool_size=64000000

View Answer   |  May 12, 2004  1:09 PM
Oracle, Oracle 10g

Oracle Streams
I do not have any experience with Oracle Streams. Sitansu S. Mittra

View Answer   |  May 12, 2004  12:29 PM
Oracle

export RECORDLENGTH
From the 8.1.7 Utilities Manual, the chapter on Export RECORDLENGTH Default: operating system-dependent Specifies the length, in bytes, of the file record. The RECORDLENGTH parameter is necessary when you must transfer the export file to another operating system that uses a different default value. If you do not define this parameter, it defaults to your [...]

View Answer   |  May 12, 2004  11:13 AM
Oracle 8i

Oracle Materialized Views – Fast Refresh
Prerequisites: grant query rewrite to <user_creating_mv> as SYSDBA alter session set query_rewrite_enabled =true; alter session set query_rewrite_integrity=enforced; Say your base table is table_a with a primary key. You create a materialized view log on table_a create materialized view log on table_a; Now to create a materialized view that will refresh when ever the table is [...]

View Answer   |  April 28, 2004  10:35 AM
Oracle