RE: Setting db_block_size with installer

Chris - DB_BLOCK_SIZE is still there definitely. And I am confident that a create database script from 8.1.7 will work against 9.2 just fine. The issue is that the dbca (GUI Database Configuration Assistant) wants to create everything as 4k block size. Rachel, Joe - Thanks for the suggestions

RE: Oracle Applications Development Database Refresh

Thanks Scott, I'll give that a try first. Jared [EMAIL PROTECTED] 07/08/2002 02:21 PM To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject:RE: Oracle Applications Development Database Refresh My apps person tells me that they just restore the db

RE: slightly OT, permissions unix/oracle puzzler

I found this on the metalink: Default permissions are rw-r--r--,which can be overridden by the following factors: 1) The Oracle instance owner's Unix umask since Oracle is the owner of all the server processes. It is the server process that writes the UTL_FILE output file. 2) For network

RE: slightly OT, permissions unix/oracle puzzler

Ok but why would I create a new group? Couldn't I just chmod the permissions on the directory directly? I understand what your saying but my problem is more than just utl_file and it is ok on one system A and not the other system B oracle dba are the owner and groups on BOTH systems. If

RE: slightly OT, permissions unix/oracle puzzler

First off, I can't answer any OEM questions. I don't use it, and don't care to. You can probably do this without changing the group of the directory, but then all users wishing to access it would require membership in the dba group. This is ok as long as only DBA's are accessing the files.

RE: slightly OT, permissions unix/oracle puzzler

umask is the same for oracle on both machines and listerner owner and group is oracle dba on both machines and both listeners have been started by oracle Thanks Kathy -Original Message- Sent: Monday, July 08, 2002 3:59 PM To: Multiple recipients of list ORACLE-L I found this on the

RE: Setting Up EXTPROC

Some security and Intermedia tips: Make sure the extproc listener runs under a non-privileged account. In UNIX the nobody account should be used. Do not setup anything but an ipc connection. If you are running Intermedia make and need to do docment filtering make sure nobody's

RE: download leads to sales call

I never got a call for downloading Oracle 9i but they called me for downloading Developer 6i and they even called me for downloading an ODBC driver. These calls came after about 6 weeks after downloading the products. They wanted to know what I was doing with Developer 6i and I told them I was

RE: 2003 IOUG Meeting

IOUG-A. No question. Much less Oracle Marketing hype. -Original Message- Sent: Monday, July 08, 2002 5:18 PM To: Multiple recipients of list ORACLE-L Hi, All. Before this thread ends, take a swing at this, please: Assuming one can only attend a single conference per year, which is a

RE: 2003 IOUG Meeting

we've had this discussion here before.. OpenWorld has more Oracle presentations, many of which have a definite marketing slant. I was very frustrated at the percentage of this is how we say it works presentations vs this is how it works out in the real world presentations IOUG has almost all

Re: RE: table size.

Ji, Richard£¬ÄúºÃ£¡ hi, i think doing it with exp compress=N and It should use less space. If you are in oracle8i+, i think doing : alter table move tablespace new_ts storage(new storage clause) is faster, and then do: alter index index_on_the table rebuild (nologging if possible).

RE: Increase size of REDO log

5 days ago ? check your alert log for the date and time of log switch -Original Message- Sent: 09 July 2002 04:14 To: Multiple recipients of list ORACLE-L How about if I use LogMiner to read redo log to check which transaction had been modified in 5 days ago, how do I know which redo

RE: Oracle Applications Development Database Refresh

If anyone has refreshed the Dev database from the Production database Oracle HRMS 11/11I successful, please tell me how to do it ? Thanks. Regds, New Bee -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent:

Re: Comparison between Oracle 8 and Oracle 9

Are their claims based on actual experience with 9i or are they simply regurgitating Oracle's marketing line? It may well be better in many respects, but beware of consultants who make recommendations based on what they may have read somewhere - especially if the source vendor press releases or

Re: Copy

I know it existed in Oracle6 - and just checked my handy Oracle 6.0 SQL*Plus v3.0 Quick Reference (circa 1991) to be sure. The only v5 manual I could find easily is my Database Administrator's Guide for Version 5.1 (circa 1986) and it contained no information on the copy command, but I'm pretty

RE: table size.

Dear Mitchell, If iam not mistaken the delete command does not free up the space..but it can be used in the future 4 the other records that r inserted... but incase of Truncate statement the tablesapce is freed of space u can try it out on a temporary table regards, Ams. -Original

Fw: Error on creating index

Thank you all for your interest. 1 - I did not get any error message. 2 - I do not have an index named index_1 in the USER1 schema. 3 - Oracle stops means oracle crashes without an error. It gets stuck. It waits forever and no other user(s) may connect to it. 4 - Oracle version Oracle

<    1   2