techiey2k3's articles:

Items(40) /4 Next >> Last >|

truncate partition #2 3 25 (5/12/2005 11:52:20 PM) comp.databases.oracle.server with update global indexes. We did this on 2 partitions of different tables today and timings were very different.One was 10 minutes and other was 100 minutes. Number of rows are similar but the table that to... Oradba_Linux

online redef 1 18 (4/20/2005 12:07:48 AM) comp.databases.oracle.server Why should there be a restriction on putting the interim table in nologging mode during online redef? I tried doing a redef putting the interim table in nologging mode and it worked without any issues. It gen... Oradba

partition change tracking 0 28 (4/19/2005 2:58:39 AM) comp.databases.oracle.server Has anybody used partition change tracking? Any white papers on otn about this feature. We are on oracle 9iR2. ... Oradba

block size #2 2 29 (4/12/2005 11:20:20 AM) comp.databases.oracle.server We are going to build an oracle 9204 RAC database on Redhat linux. We will be using veritas storage foundation for oracle raac to build the filesystems.what block size should we use for the database and how to ... Oradba

Block size 2 35 (3/28/2005 2:21:19 AM) comp.databases.oracle.server Is there a white paper that could help me decide on the block size for a database? What to consider before making that decision? ... Oradba

truncate partition 1 23 (3/25/2005 1:10:55 PM) comp.databases.oracle.server I did a truncate partition with update global indexes clause. It was a big partition and it failed with temp space error. When i looked at what sql it was running internally it was an insert statement. Anybody ... Oradba

dbms_stats #3 2 61 (1/29/2005 12:41:39 AM) comp.databases.oracle.server Can i copy the stats for a table to another table - one is non-partitioned and another will be online redefined into a partitioned table Will this work well ? Instead of regathering stats after partitioning the... Oradba

analyze index 17 34 (1/25/2005 12:56:32 AM) comp.databases.oracle.server Why would analyze index command read table segments? ... Oradba

Triggers 4 21 (1/20/2005 1:26:48 AM) comp.databases.oracle.server On the hr.employees table, i have a 3 triggers - before update , before update for each row , after update for each row .. They only have dbms_output as part of the code. SQL> create or replace trigger trg_emp... Oradba

Coalesce index 1 33 (1/20/2005 1:11:36 AM) comp.databases.oracle.server What is this used for ? Can this be done online? ... Oradba

techiey2k3's replies:

Items(47) /5 Next >> Last >|

Full Table Scans 6 21 (2/8/2005 11:33:58 AM) comp.databases.oracle.server Hi We have monitoring software which is telling us that many full table scans are happening in the database. We want to reduce this if possible. Is there any SQL to use to tell what is doing the full tablesc... biwombi (27)

invalid objects and partitioning 11 28 (2/9/2005 8:08:09 PM) comp.databases.oracle.server I have a need to partition several tables using a date column. Each table may be partitioned into say 7day period, 15day period, 6month period. In other words, I am trying to preserve data for 7days etc. I h... rangwalamustafa (5)

Assessment question on indexes 17 34 (2/10/2005 12:10:08 AM) comp.databases.oracle.server A certain OCA/OCP Introduction to Oracle9i SQL study guide contains the following question. Which of the following statements could use an index on the columns PRODUCT_ID and WAREHOUSE_ID of the OE.INVENTORIES... stoopidstoopidstoopid (13)

uploading the contents of a spreadsheet 11 34 (4/26/2005 8:10:27 AM) comp.databases.oracle.server Hi, I have never worked with Oracle before and I need to update a database with the contents of an Excel spreadsheet. Since I do not have the database structure the first order of business is to be able to ex... dsotiriades (4)

index creation fails because temp tablespace is too small 28 27 (4/27/2005 3:03:49 PM) comp.databases.oracle.server Hi, i have a problem. I'm enabling a unique constraint, that is creating a index on a table. The table contains 135000000 rows ( 13 GB) my temp tablespace is 3 gb big. when i enable the constraint it keeps... karelje007 (2)

TOAD tablespace-map? 3 29 (5/9/2005 12:41:28 PM) comp.databases.oracle.server Hi, I recently tried to use the view "DBA/Tablespace Map" in TOAD, but I am not sure how to interpret this screen. What puzzles me is: e.g. that we have a tablespace that by dba_extents and dba_segments is 80... grz01 (103)

Automating RMAN 7 25 (5/12/2005 8:26:25 PM) comp.databases.oracle.server Hi, We now use RMAN to back up. We will keep one full week on disk, and 2 weeks on tape. I was searching the net for some commands to automate the cleanup of the recovery catalog. Once 2 weeks have passed,... amerar (454)

Can not see 9i Linux RH Server from client 6 37 (5/12/2005 10:10:29 PM) comp.databases.oracle.server Hi, Am stumped here. Have a 9i rh as 3 db which looks great on the server. Can sql plus and query away no problems. But ..... try and have a client see it and it get a problem connecting. Any ideas greatly a... saustin (16)

truncate partition #2 3 25 (5/12/2005 11:52:20 PM) comp.databases.oracle.server with update global indexes. We did this on 2 partitions of different tables today and timings were very different.One was 10 minutes and other was 100 minutes. Number of rows are similar but the table that to... techiey2k3 (103)

font problem in oracle 10g 5 30 (5/23/2005 8:38:30 AM) comp.databases.oracle.server hi i am using window xp 2004 and oracle 8i client (in my client machine) ..... i have designed an interface using vfp that connect to oracle 10g database server in other machine...... now my problem is when i ... forum938 (21)