Question on snapshots

the snapshot: CREATE SNAPSHOT hfsas_main.hfc_rvp_wave_data storage ( initial 128M next 128M pctincrease 0) tablespace hfsas_data_large refresh complete as SELECT * FROM [EMAIL PROTECTED] / -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke INET

RE: New to DBA !

I think you can still use svrmgrl to login to the database Unix svrmgrl SVRMGR connect internal SVRMGR alter user system identified by manager; I hope this helps. Ashoke SVRMGR-Original Message-From: Rama, Shreekantha (K.) [mailto:[EMAIL PROTECTED]Sent: Tuesday, October 21,

What is the best way to download the Metalink Notes

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

What are the restrictions in naming an Oracle SID/Database?

. Is there any other restrictions? Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: What are the restrictions in naming an Oracle SID/Database?

restrictions? SID names should be unique. --Senthil. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

How to migrate the LDAP data into Oracle 8.1.7 database tables?

. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Is there any user group forum for SQL Server?

Hi All, As we have this Oracle user group([EMAIL PROTECTED]), I was wondering if there is any such group for SQL Server also. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Snapshot refresh questions

changing of refresh time. Thanks for your help, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Oracle 8.1.6 Installation error

this. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

How to restrict a trigger from firing when the DML is done remotely

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

How to pass value from SQL*Plus to Unix scripts?

system manager AMERICAN_AMERICA.US7ASCII How can I pass the character set to the export script? Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Oracle User identified EXTERNALLY

Sep 6 10:44:27 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. Enter password: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: materialized view of a remote partition

: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself

OCP - Oracle 9i upgrade study Materials

://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

RE: off topic: OCP exam registration

ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Sample questions on OCP 8i new features upgrade

website where I can get some free sample questions, then please let me know. Thanks for your help in advance, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

password aging and expiration in oracle 8.1.7

Title: RE: How to notify the password expiration in oracle? Hi All, I am trying to implement the password aging and expiration. The password for some of the users have expired on August 23, 2002. When I try to login it does not give any warning. Only thing I observed that the

Materialized View

Title: RE: Simple question on logging.. Hi All, Is it true that I cannot create a materialized view by accessing a remote table? Here is the syntax for creating the materialized view but it does not work. REM Create materialized view mast_time_mvCREATE MATERIALIZED VIEW mast_time_mv

SQL*Loader : How can I load the Line Feed as part of data

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

RE: SQL*Loader : How can I load the Line Feed as part of data

by clause.. you can override the default terminator of line feed. You can also concatenate multiple lines together --- Mandal, Ashoke [EMAIL PROTECTED] wrote: Greetings, We have one column in a table and this column need to store data with Line Feed, denoted by \x0d\x0a in the following row

How to notify the password expiration in oracle using email?

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

How can I check the time when any table is updated under a schema?

LAST_DDL_TIME TIMESTAMP Any idea? Thanks in advance, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

How to notify the password expiration in oracle?

expiration or as the password has just expired. Any ideas? Thanks in advance, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: RMAN Restore problem

of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal

RMAN Restore problem

Title: converting fmt to fmb Greetings, I am trying to restore a database into a new host. The database calleddsdn is originally located on dndev, catalog database is located on catserver1. I have copied the catalog to a database called trmanrfd, which is also located on the new host

RE: How to read REDO log

Title: RE: ORA-27101 Error I think you can do this being ina 8i database. -Original Message-From: Nguyen, David M [mailto:[EMAIL PROTECTED]]Sent: Monday, July 01, 2002 12:29 PMTo: Multiple recipients of list ORACLE-LSubject: How to read REDO log Can I setup LogMiner to

How to grant privileges on all the tables of owner1 to owner2?

to owner2; . . . grant select,insert,update,delete on owner1.table150 to owner2; I was wondering if there is any way I can perform the same work using one sql statement instead of using 150 statements. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke

RE: How to drop a data file from a tablespace quickly

, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City

RE: SIMPLE QUESTION

: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself

Oracle 8i installation help

document from Oracle, where it specifies about this. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: Oracle-l conference (was RE: ANTI-VIRUS SPAM - YOUR EMAIL

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

Files which can be deleted from ORACLE_HOME to release space

from Oracle, where it specifies about this. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

URGENT : contact phone of Oracle Support

Could any of you send me the 1-800 no. and also the other phone no. for contacting Oracle support. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

GOT IT : URGENT : contact phone of Oracle Support

-- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

RE: RE: SQL giving problem over the database link

Reply Separator Author: Mandal; Ashoke [EMAIL PROTECTED] Date: 4/22/2002 11:53 AM It is supposed to return 15 rows. Thanks, Ashoke -Original Message- Sent: Monday, April 22, 2002 2:34 PM To: Multiple recipients of list ORACLE-L How many rows

SQL giving problem over the database link

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

RE: SQL giving problem over the database link

from fw.fwlot where fw.fwlot.appid = '205956'); Any explanation or help is appreciated. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: SQL giving problem over the database link

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

RE: SQL giving problem over the database link

, I tried this and still it hangs. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: Deleting old archive log files.

-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: RMAN Core dumps while restoring datafile

-08017: channel t1: starting archivelog restore to default destination RMAN-08022: channel t1: restoring archivelog RMAN-08510: archivelog thread=1 sequence=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services

RMAN Core dumps while restoring datafile

command: recover(4) RMAN-08017: channel t1: starting archivelog restore to default destination RMAN-08022: channel t1: restoring archivelog RMAN-08510: archivelog thread=1 sequence=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat

RE: Seeking opinions

command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Help in unix script

with the value. top -b -U norad | grep norad | awk '{ print $6, $11 }' | \ while read SIZE COMMAND do echo Command : $COMMAND Size : $SIZE done Any suggestions will be appreciated. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET

OCP Test on Oracle 8i New features Upgrade : study Materials, URLs, Sample questions

: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself

Study Materials, URLs, Sample questions for Oracle 8i New features Upgrade OCP Test

: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself

RE: ORA-00600 errors

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

RE: RMAN Question

) in the disk so that we don't need to restore the archive logs from rman backup in case of some recovery up to point within last 2 days. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services

RAMAN Question

of some recovery up to point within last 2 days. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: URGENT Help on tracking unauthorized login to Oracle Database

Principal DBA Chartered Semiconductor Manufacturing Ltd Mandal, Ashoke [EMAIL PROTECTED] 12/02/2002 01:18 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L

Preparation for OCP 8i Upgrade

Is there any book for Oracle 8i upgrade Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Thanks : URGENT Help on tracking unauthorized login to Oracle Database

I don't know in which section you can find that in the Administrator Guide. Rivaldi -Original Message-From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]]Sent: Monday, February 11, 2002 11:18 PMTo: Multiple recipients of list ORACLE-LS

RE: URGENT Help on tracking unauthorized login to Oracle Database

of list ORACLE-LSubject: RE: URGENT Help on tracking unauthorized login to Oracle Database Administrators guide. Chapter on auditing. Audit session. Rivaldi -Original Message- From: Mandal, Ashoke [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 12:54 PM

URGENT Help on tracking unauthorized login to Oracle Database

database with invalid userid or password but with valid connect string. If there is no options under oracle then is there any 3rd party software for this purpose. Any help is appreciated Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal

RE: URGENT Help on tracking unauthorized login to Oracle Database

To: Multiple recipients of list ORACLE-L Database Administrators guide chapter on auditing. joe Mandal, Ashoke wrote: Greetings, We have a database with very sensitive data. Our management wants me to find out the way to secure this data from unauthorized login and track these users who tried to login