Index Being Used?

Hello all, I would like to drop a particular index. Before I do, I'd like to check to see if has been accessed recently (or at all). How can I check this? Chris Rezek Oracle DBA Digital Music Network http://www.dmn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

Re: Substitute for Materialized Views/Snapshots?

message? Perhaps it has nothing to do with the fact that you're running SE. HTH, -- Anita --- Chris Rezek [EMAIL PROTECTED] wrote: Anita - I checked 112591.1 and also filed an iTAR to confirm with Oracle - there is no materialized view functionality for SE. Chris - Alas

Re: Substitute for Materialized Views/Snapshots?

The error is: SQL create materialized view test_age as select * from age; ORA-12028: snapshot type is not supported by master site Chris Rezek wrote: Anita, I would be a very happy man today if snapshots existed in SE. However, I have verified the non-existence of snapshots in SE

How do I check for partial duplicates?

. Thanks, Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: How do I check for partial duplicates?

the same MEM_TIME and MEM_LAST is okay. Thanks, Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Re: How do I check for partial duplicates?

the records have been entered sequentially I went with ROWID which was faster. Thanks guys! Chris Rezek Oracle DBA Digital Music Network http://www.dmn.com Seley, Linda wrote: This will delete all single rows (where select mem_id,mem_name,count(*) from mem_info group by mem_id,mem_name having count

Re: Substitute for Materialized Views/Snapshots?

--- Chris Rezek [EMAIL PROTECTED] wrote: We are running 8.1.6 Standard Edition on Solaris hardware. We are building a reporting system and would have liked to use materialized views (snapshots) but this feature is not available in Standard Edition. We need to create read

Substitute for Materialized Views/Snapshots?

at midnight. How can we do this without Oracle's auto-updating materialized views? Chris Rezek Oracle DBA http://www.dmn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Can the initABCD.ora file be changed during an RMAN migration

the database. I know I don't want to change db_block_size - but what else should I not change? Chris Rezek Oracle DBA DotClick Corporation http://www.dotclick.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek INET: [EMAIL PROTECTED] Fat City Network

Re: RMAN backup pieces

but I need to split the backup up because of a 2GB file size limit (I'm backing up files from a Solaris box to a Linux box). Chris Rezek Oracle DBA DotClick Digital Music Network http://www.dotclick.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek

RMAN backup pieces

How do you split a RMAN backupset into multiple pieces? I am using Standard Edition so I can't use multiple channels but I need to split the backup up because of a 2GB file size limit (I'm backing up files from a Solaris box to a Linux box). Chris Rezek Oracle DBA DotClick Digital Music Network

Re: Drop 'NOT NULL' Constraint

which generated constraints (from user_constraints) do what? Chris Rezek Database Administrator DotClick http://www.dotclick.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek INET: [EMAIL PROTECTED] -- Please see the official

Drop 'NOT NULL' Constraint

? Chris Rezek Database Administrator DotClick http://www.dotclick.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Security Functions

How do I restrict access to functions? Chris Rezek Database Administrator DotClick http://www.dotclick.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: Security Functions

Whoops - just realized all I needed was a 'grant execute'. Chris Chris Rezek wrote: How do I restrict access to functions? Chris Rezek Database Administrator DotClick http://www.dotclick.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek

SPARC vs. RS/6000 - which has better performance/processor?

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

EXPORT vs. Hot Physical Backup

Which is a better way to back up a database - use EXPORT/IMPORT or physical datafile backups? Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Physical Data Layout

? Thanks, Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists