How to port a DB(Ora815) on a different server (sameOS) but Ora817?

Hi to all, I have to port a DB (Ora815, NOarchivelog) on a different server (same OS Solaris), where there is already installed ORA817. I'm thinking of doing OLD SERVER -Shutdown immediate -Copy of db-files,redo,script for generate new ctl ,init,tnsnames NEW SERVER-On the 817 instance

Fwd: RE: Raw partition Vs File System

Hi Steve, Did you manage to contact Bert? Would you be willing to let us know what you think was wrong with the test anyway? Many thanks - Bill. Hi All, Does anyone have an email address for Bert? I looked for his email address when I first read that article a week ago, but did not find

Oracle 7 password security

Does anyone know of a way of implementing password ageing/standards etc in Oracle 7 other than through third-party products or have experience of any third-party products which do this. Unfortunately Oracle 8 is not an option. Cheers Iain Nicoll -- Please see the official ORACLE-L FAQ:

RE: RE: Raw partition Vs File System

Hi Bill, No luck contacting Bert. My guess is that he did not have a very big SGA, so there was plenty of his 2G of RAM available for filesystem caching. For example, if Oracle had 128M for the shared pool and 128M for its buffer cache (as at the end of his previous article in the series),

Re: How to port a DB(Ora815) on a different server (sameOS) but Ora817?

That won't work buddy, you will have to use the migration/upgrade tool to update the Data files to the new 'format' that oracle 8.1.7 uses if you want to copy it straight across. The easiest way would be to use a dump file no..? Make sure and keep the DB block size the same in the init.ora !

Oracle 8i vs. 9i on linux.

I was wondering if anyone had any thoughts about which version of either 8i or 9i would be better to run on Linux? 9i seems to support larger database files, but I'm wondering if I would be giving anything up to move from 8i. Any thoughts? Thanks! -- Jesse W. Asher They that can give up

Oracle DB_Diff

I have an Oracle Compare Script written in Perl that will compete with DB_Diff in OEM, all you require is perl, DBI, DBD::Oracle and if you want upgrade scripts created then DDL::Oracle (http://sourceforge.net/projects/ddl-oracle/) It is much faster and as configurable as DB_Diff with the

How to Drop a Table

I am deleting the demo DB. First I dropped the tablespaces - USERS and TEMP. Now I want to drop the four tables. However, when I tried it I get an error that these tables do not exist. I guess I should have dropped the tables first then the tablespaces. So, how do I drop these tables?

function based index

hi everyone we have a query with several max functions in it. The performance of the query is not so well, can i achieve better performance with function based index on max(columnname)? according the manuals this is not allowed because max is a group function. anyone with a solution for this

Ora-1031 (Insufficient Privileges) Inserting BLOB Data With Perl

One of our developers has written a program to upload files into the database via perl. The actual file contents are stored in a blob. The table was created with the following script CREATE TABLE BP_FILES (FILE_ID NUMBER(7,0) NOT NULL ,FILE_TYPE VARCHAR2(1) NOT NULL ,FILE_FORMAT

Re: How to port a DB(Ora815) on a different server (sameOS) but Ora817?

Hi, Recently been cloning a 8.0.5 database to different server (Same OS) with Oracle version 8.1.7 copied all the db files and recreated the controlfile (renamed the database) and did open resetlogs (no need to copy the redo log files across). Database opened just fine using the 8.1.7

Re: How to Drop a Table

Logon as a dba or as sysdba, then try to drop them. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 7:45 AM I am deleting the demo DB. First I dropped the tablespaces - USERS and TEMP. Now I want to drop the four

RE: How to Drop a Table

Ken If you said DROP TABLESPACE INCLUDING CONTENTS, then the tables have been dropped. HTH Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 20, 2001 7:45 AM To: Multiple recipients of list ORACLE-L I am deleting the demo DB. First I dropped

Re: How to Drop a Table

Ken, They should already be gone if they were created in the USERS tablespace. When you query for them, do you see them at all? If you can't see them in the DBA_TABLES view then they were implicitly dropped when you dropped the users tablespace. Do you need the TEMP tablespace for anything

Re: Oracle 8i vs. 9i on linux.

Jesse, we're working on Linux. Stability is the first thing you should consider while choosing right version of Oracle for a production system (especially on Linux). I would do hara-kiri myself if my boss told me migrate on 9i now. Regards, Ed I was wondering if anyone had any thoughts

RE: How to Drop a Table

Ken, If you are going to reuse the database, make sure that you have a TEMP tablespace of some sort available to use. Perhaps you had a TEMP and a TEMP01 or something like that. Then when you dropped the TEMP tablespace, you should still be o.k. But if you only had that one TEMP

applying patch 2032040 to Oracle Purchasing

Title: applying patch 2032040 to Oracle Purchasing After applying the c.drv portion of the patch, I'm attempting to apply the d.drv portion of patch the patch above and adwork1 is failing applying the d.drv file. In the adwork1.log file I see, jre -mx128m -nojit

RE: How to Drop a Table

I got around it by using DBA Studio. Thanks, Ken -Original Message- Sent: Tuesday, November 20, 2001 7:35 AM To: Multiple recipients of list ORACLE-L Subject:Re: How to Drop a Table Logon as a dba or as sysdba, then try to drop them. Ruth - Original Message -

Re: Ora-1031 (Insufficient Privileges) Inserting BLOB Data With Perl

Do 'other users' have any quota on 'BABAR_PAPERS_DATA' tablespace (where LOB is stored)? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 8:15 AM One of our developers has written

Metalink gone to sleep ?????

Can't log in to Metalink today either...am getting the opening page but gives the 'Page temporarily unavailable' after that..anybody else sharing the same problem Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone

Re: function based index

hi everyone we have a query with several max functions in it. The performance of the query is not so well, can i achieve better performance with function based index on max(columnname)? according the manuals this is not allowed because max is a group function. anyone with a solution for this

RE: How to Drop a Table

Thats cheating!!! :-) -Original Message- Sent: Tuesday, November 20, 2001 9:00 AM To: Multiple recipients of list ORACLE-L I got around it by using DBA Studio. Thanks, Ken -Original Message- Sent: Tuesday, November 20, 2001 7:35 AM To: Multiple recipients of list

RE: RE: Raw partition Vs File System

Bill, There is a chance that Linux is using direct io (most Unixes have some variant of this) and that -- at least for some I/O -- that the OS buffer cache is bypassed. Food for thought. Ross -Original Message- Sent: Tuesday, November 20, 2001 6:05 AM To: Multiple recipients of

RE: Metalink gone to sleep ?????

I just connected with no problems. -Original Message- Sent: Tuesday, November 20, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Can't log in to Metalink today either...am getting the opening page but gives the 'Page temporarily unavailable' after that..anybody else

Re: Oracle 8i vs. 9i on linux - stablility issues with 9i?

So, you believe there are stability problems with 9i on Linux? Anyon else have similiar experiences?? Edward Shevtsov wrote: Jesse,we're working on Linux. Stability is the first thing you should considerwhile choosing right version of Oracle for a production system (especiallyon Linux).I

Re: Metalink gone to sleep ?????

I tried to log on to metalink today(11/20/2001) got the same error. Mujeeb Chowdhry [EMAIL PROTECTED] 11/20/01 09:45AM Can't log in to Metalink today either...am getting the opening page but gives the 'Page temporarily unavailable' after that..anybody else sharing the same problem

Upgrade to Solaris 8

Hi, Could anybody tell me if I need to take any steps as regards my database when I upgrade my OS from 32-bit Solaris 7 to 64-bit Solaris 8 ?? This is version 8.1.6.3. Thanks and Regards, Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL

lsnrctl - can I remove world executable privileges?

Had a bit of a shock this morning. I never knew that the lsnrctl was -rwxr-x--x by default and a random unix user shut down the listener on our production database. Is there any reason not to change the privileges on this file, making it -rwxr-x---? Is there a reason it's set this way? This

SESSION UGA MEMORY MAX

Hi there, anybody out there who can give me some hints for the following effects. I have an oracle dedicated server 8.1.6 on unix with 1GB of memory. I have to tune the system and I am looking for bottlenecks. Now I found the following: There are some sessions with a value for SESSION UGA

RE: Ora-1031 (Insufficient Privileges) Inserting BLOB Data With P erl

Resource on the tablespace should not matter. I don't want them to be able to create segments, but to perform DML on the lob_segment already there. If I use sqlplus and the dbms_lob functions in an anonymous pl/sql block then the insert is successful when the privileges on the table are

Re: Metalink gone to sleep ?????

No, I am working fine on metalink (from Italy). - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 3:45 PM Can't log in to Metalink today either...am getting the opening page but gives the 'Page temporarily

RE: Unable to rebuild database from hot backup

Sorry I never got back to people on this (since I got my restore to work using the standby controlfile I didn't pursue it for a while and then I forgot to respond until I was cleaning up old messages). The issue was adding the until cancel clause. Thanks to everyone who suggested it and special

Re:Fwd: load flat file to Oracle

SqlLoader has a command line parameter called DATA which is the name of the data file to be processes. You can do a little old fashion DOS type batch file that will handle this. Your command would look something like: for %%a in (*.csv) do sqlldr data=%%a Dick Goulet

OT: Oracle and MQ

Hi - Does anyone have experience with using MQ w/Oracle. We have an application that is using MQ to get data from the mainframe into Oracle. We are trying to determine what our options are for retrieving the data from the MQ queues. We know one option is to write a Pro*C program to handle

RE: load flat file to Oracle

Write a script that will parse thru a file listing of the directory and do not put the incoming file name in the control file. Use it on the command line. -Original Message- Sent: Tuesday, November 20, 2001 10:01 AM To: Multiple recipients of list ORACLE-L Sorry, can't help at the

Backup strategy

Just throwing something out cause I am not sure if I am thinking correctly. I have a database that is not using partitioning so we split each month out into seperate tables/indexes by month and store them in their own tablespaces. These are kinda big so we occasionally put a tablespace into

RE: Ora-1031 (Insufficient Privileges) Inserting BLOB Data With P erl

A correction to my last the sql*plus program works with roles as well as direct grants. Ian -Original Message- Sent: Tuesday, November 20, 2001 6:30 AM To: Multiple recipients of list ORACLE-L Perl Do 'other users' have any quota on 'BABAR_PAPERS_DATA' tablespace (where LOB is

RE: lsnrctl - can I remove world executable privileges?

Give the listener a password. -Original Message- Sent: Tuesday, November 20, 2001 7:56 AM To: Multiple recipients of list ORACLE-L Had a bit of a shock this morning. I never knew that the lsnrctl was -rwxr-x--x by default and a random unix user shut down the listener on our production

Re: sequence of numbers

Thanks to all who send answers and ideas - Larry Ekins, Connor McDonnald, Jeffery Stevenson. JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: Metalink gone to sleep ?????

Ok...got it now through another link.http://oracle.com/support/metalink Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018

Re: lsnrctl - can I remove world executable privileges?

Yep, noticed it and changed it to 750. No problems. It probably gets fixed on the 8.1.7.2 patch release which I haven't done yet :). Gene [EMAIL PROTECTED] 11/20/01 10:55AM Had a bit of a shock this morning. I never knew that the lsnrctl was -rwxr-x--x by default and a random unix user

Distribution of 4 DB in a Symmetrix Box -- URGENT

Hi everybody I've 4 DB (Oracle 7.3.4- HPUX- Filesystem based) that reside in a Symmetrix box. Sym disks are configurated as follows: 8 DISKS (36GB) RAID1, SO I SEE ONLY 4 DISKS 36GB 8 DISKS in RAID-S (2 RAID-S groups) I've done this distribution: 1st RAID 1 -redo (db1)

hottbackup questions

Hi How to take hotbackup of read only tablespace? In case of media failure how to restore it? Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ:

RE: Metalink gone to sleep ?????

I can't log into MetaLink either right now using http://metalink.oracle.com/metalink/plsql/ml2_gui.startup http://metalink.oracle.com/metalink/plsql/ml2_gui.startup Will try the link you mentioned... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original

BLOB to LONG

List, Is there any way to convert BLOB column to LONG column or NOT? Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain

RE: load flat file to Oracle

dos prompt copy *.csv all.csv In the ctl file, use all.csv.? p- *-Original Message- *From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jared Still *Sent: Tuesday, November 20, 2001 9:01 AM *To: Multiple recipients of list ORACLE-L *Subject: Fwd: load flat file to Oracle

RE: hottbackup questions

You cannot take a hotbackup of a read only tablespace. However, you can copy it somewhere and back it up there. Just make sure you backup your controlfile though as it reflects that change. -Original Message- Sent: Tuesday, November 20, 2001 9:25 AM To: Multiple recipients of list

RE: Metalink gone to sleep ?????

I can connect via Oracle Canada - I think they are converting MetaLink to Oracle Portal, they Oracle Canada site looks like Oracle Portal. ??? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin,

Re: Metalink gone to sleep ?????

Boivin, Patrice J wrote: I can't log into MetaLink either right now using http://metalink.oracle.com/metalink/plsql/ml2_gui.startup http://metalink.oracle.com/metalink/plsql/ml2_gui.startup worked Ok for me. -- -- Bill Shrek Thater ORACLE DBA Telergy,Inc.

Re: Fwd: load flat file to Oracle

Deejay, Try putting the source file name in the xxx.par file that also lists the xx.ctl file. Then you only have to change the xxx.par file if the xx.ctl actions are identical. CONTROL= somefile DATA= source file I don't know if the DATA=can be a variable or not. If it can then use a for-loop

Re: Backup strategy

Kimberly, You can change a tablespace to read only with no problems and you should take a backup to capture the change. Your last paragraph stated you wanted to move the datafile to the disk that the tape backup picks That will cause you problems if you move the datafile. You should copy the

RE: Metalink gone to sleep ?????

Well, MetaLink worked for a while, but when I tried to look at another TAR the login prompt re-appeared. When I entered my name and password I got this response: Authorization Required This server could not verify that you are authorized to access the document requested. Either you supplied the

RE: lsnrctl - can I remove world executable privileges?

Thanks, I'll probably do this also now, after I change the permissions. How does one code a password into a script to stop and start the listener? Jay Miller -Original Message- Sent: Tuesday, November 20, 2001 11:30 AM To: Multiple recipients of list ORACLE-L Give the listener a

RE: set_sql_trace_in_session

For some reason I was shying away from the logon trigger approach but now I've reconsidered. Here's what I'm testing on: - CREATE OR REPLACE TRIGGER dbmon_logon AFTER LOGON ON DBMON.SCHEMA BEGIN DBMS_SESSION.SET_SQL_TRACE (TRUE) ; END ; / To toggle

Re: How to port a DB(Ora815) on a different server (sameOS) but Ora817?

I experienced problems after upgrading an 8.1.5 to 8.1.7 with my databases, using the oracle data migration tool did fix these though... I'm guessing this java tool just runs the relevant scripts i.e. (u08000500.sql) ? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

RE: Backup strategy

My fault, I should have said copy. Climbing night last night so I am dead tired. Thanks for the input. -Original Message- Sent: Tuesday, November 20, 2001 10:10 AM To: Multiple recipients of list ORACLE-L Kimberly, You can change a tablespace to read only with no problems and you

RE: hottbackup questions

Smith You are talking about backup of conrol file by alter database backup controlfile to trace; or alter database backup controlfile to '/u07/oradata/bckcorp.ctl' reuse; Let me know please Thanks -Seema From: Kimberly Smith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients

RE: Backup strategy

My hot backup is to put one tablespace in backup mode one at a time and copy that data file to disk and alter it back online. No problem Bing -Original Message- Sent: Tuesday, November 20, 2001 10:28 AM To: Multiple recipients of list ORACLE-L My fault, I should have said copy.

RE: Backup strategy

Ya but you don't normally backup a read-only tablespace. The whole reason I make them read-only is to ensure that I finish the backup this century. -Original Message- Sent: Tuesday, November 20, 2001 11:01 AM To: Multiple recipients of list ORACLE-L My hot backup is to put one

RE: hottbackup questions

Just follow your regularly scheduled backup plan. Personally I use the second one you use. Its a little different to recover a read-only tablespace though depending on which control file you use and what state your tablespace was in compared to you control file when failure occurred. There

Index not being used .... why?

This is from my user I can't figure why Oracle is not using the index even with a hint. Optimizer mode is RULE. BTW the query always returns NULL value. I'm running a simple query. It's taking too long. Ran an explain plan on it and it's doing a full table scan for some reason. I've tried

Index File Name

I am creating a database from a DDL SQL script. I have created the primary and temp tablespaces because their names were referenced in the code. However, there is no name reference anywhere that I can find for the index tablespace. Do I need to create one, or will Oracle take care of that for

RE: Backup strategy

When you backup the read-only tablespace, you must backup the archive logs (if any) as well. -Original Message- Sent: Tuesday, November 20, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Ya but you don't normally backup a read-only tablespace. The whole reason I make them

v$sqltext

Dear listers, Could anyone give me some hint why the following sql is running extremly slow? Is that normal or not? select sql_text from v$sqltext where hash_value = 3533971985 order by piece Thanks and happy holidays Shu -- Please see the official ORACLE-L FAQ:

Re: function based index

I think, you need materialized view, function based index. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 8:00 AM hi everyone we have a query with several max functions in it.

RE: Index not being used .... why?

Returns null or no rows? If it is null then something weird is going on... -Original Message- Sent: Tuesday, November 20, 2001 1:23 PM To: Multiple recipients of list ORACLE-L This is from my user I can't figure why Oracle is not using the index even with a hint. Optimizer mode

What?! Re: How to Drop a Table

Could someone explain why, after dropping a tablespace, you could use DBA Studio to successfully drop tables that are already gone? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: Index not being used .... why?

Jamadagni, Rajendra wrote: This is from my user I can't figure why Oracle is not using the index even with a hint. Optimizer mode is RULE. BTW the query always returns NULL value. I'm running a simple query. It's taking too long. Ran an explain plan on it and it's doing a full table

Re: Index File Name

is there an index creation statement in the script? is the index tablespace named in it? you can name the index tablespace anything you want, except that you have to be sure to use that name when you create the index --- Ken Janusz [EMAIL PROTECTED] wrote: I am creating a database from a DDL

RE: Index not being used .... why?

I'm gonna hazard a guess that the mso_or_independent_id field may be a CHAR or VARCHAR. Try enclosing the value in single quotes and see if that helps. The implicit conversion from numeric to char would suppress index usage and it would also drop off the leading zero (which might be why you

Re: How to port a DB(Ora815) on a different server (sameOS) but Ora817?

Francesco, Sometime in the past 6 - odd months, I had to migrate a bunch of databases on NT (why NT :-)?? Not my decision, believe me !!!)from 8.1.5 to 8.1.7. Set ORACLE_HOME to the new version. Re-created the service (ORADIM). Re-created the controlfile. Ran u801050.sql. We did not run into

RE: Metalink gone to sleep ?????

I tried getting in through an e-mail from [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] (TAR update notification), and my browser said it couldn't find the server. So the IP address was gone too, that's what the link used to connect back to MetaLink. Regards, Patrice Boivin Systems Analyst

Re: BLOB to LONG

Hamid Alavi wrote: List, Is there any way to convert BLOB column to LONG column or NOT? Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 OCI program, this is all I see. -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0)

RE: Index not being used .... why?

Hey Brian ... It is a non-unique index, and as couple of members pointed it actually is a varchar2 column. So, I have now learned to describe the table myself *first*. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot

SQL Tuning

Yesterday at the SDOUG meeting Mark Gurry gave a 2 hour presentation on tuning. His slides can be found at http://www.sdoug.org/ Slide #62 held the answer to Rajendra Jamadagni index problem. He's the author of a couple of books on Oracle SQL tuning. HTH HAND! -- Charlie Mengler

RE: Index not being used .... why?

Is your column mso_or_independent_id of type NUMBER? Have you an index on this column? /Quamrul From: Norrell, Brian [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Index not being used why? Date: Tue, 20 Nov 2001

RE: Index File Name

Here is a typical piece of code from the DDL SQL script that creates an index. It appears that the tablespace used for indexes is SOS2_TBLSPC. Correct? Ken CREATE INDEX FK_AR_ACCESSRIGHTID ON ACCESS_RIGHT(ACCESS_RIGHT_ID) TABLESPACE SOS2_TBLSPC PCTFREE 10 STORAGE(INITIAL 122880 NEXT

RE: Index File Name

Title: RE: Index File Name Alistair, The index will be created in the default tablespace of the user, not in the tablespace of the table. Try it and check the results. If you create the index in the same sql statement as the table (like the primary key) then yes it may end up in the same

Re:Index File Name

Why do I get this awful feeling, something like a wet diaper, on this one? Your script should have you create the database which will create the system tablespace by default and run a number of sql scripts from the $ORACLE_HOME/rdbms/admin directory. It then should create a tablespace for

Re: What?! Re: How to Drop a Table

Dunno, don't use it, but I'd be harzarding a guess along the lines of: a) bring up list of tables in window b) drop tablespace, table list still looks same (ie not refreshed from database) c) drop table (in Studio designed to report OK if table to be dropped does not exist) Just guessing...

RE: Metalink gone to sleep ?????

I am using Metalink ... I just updated 2 Tars and got messages from tar monitoring system. No problems whatsoever .. This is about 3:30pm EST. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any

RE: Ora-1031 (Insufficient Privileges) Inserting BLOB Data With P erl

Solved??. It seems update privileges are needed on the table even though the perl script is doing an insert. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, November 20, 2001 5:15 AM To: Multiple recipients of list ORACLE-L Perl

RE: lsnrctl - can I remove world executable privileges?

lsnrctl EOF set password pass start listener EOF -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 1:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: lsnrctl - can I remove world executable privileges? Thanks, I'll

Re:RE: Index File Name

Correct! Reply Separator Author: Ken Janusz [EMAIL PROTECTED] Date: 11/20/2001 12:20 PM Here is a typical piece of code from the DDL SQL script that creates an index. It appears that the tablespace used for indexes is SOS2_TBLSPC. Correct? Ken

RE: exp a big tablespace

Title: RE: exp a big tablespace Here's a tip I mined many moons ago from I don't know where. It's a script to split the compressed file into smaller chunks using the standard UNIX split utility. HTH Tony Aponte January 16, 1998 Exporting a Database That's More Than 2GB When

RE: Index File Name

yep, absolutely. so as long as that tablespace has been created, your script will run if I were you, I'd do a search in that script file for the word TABLESPACE and find every tablespace name that is used and make sure they exist before I ran the script --- Ken Janusz [EMAIL PROTECTED] wrote:

Fw: Index File Name

Title: RE: Index File Name Sorry for the assumption... :o) I do find it best to specify the tablespace of the index to be different than the table, personally I use have a method of leaving: DB Object code i.e. packages in the users default tablespace, Tables in one tablespace (i.e.

Re: Ora-1031 (Insufficient Privileges) Inserting BLOB Data With P erl

Could it be, that it first creates a record with NULL in blob column using EMPTY_BLOB(), and then updates blob column? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 3:35 PM erl

Re: What?! Re: How to Drop a Table

I would just hazard a guess, without knowing any facts, that DBA Studio has some copy of the system tables that isn't kept in sync. In this case you aren't really dropping nonexistent tables, you're just removing rows. But that's just a guess.

RE: lsnrctl - can I remove world executable privileges?

Thanks! -Original Message- Sent: Tuesday, November 20, 2001 3:45 PM To: Multiple recipients of list ORACLE-L lsnrctl EOF set password pass start listener EOF -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 1:28 PM To:

[no subject]

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

Re: Oracle license historic price

The Oracle pricing for named:concurrent user was a factor of 2:1, I remember distinctly since we converted a number of named users to concurrent when we signed a contract for our network license agreement a few years ago. I thought that ratio was low, since you get a lot

RE: Oracle and MQ

Title: RE: Oracle and MQ I believe Oracle sells an MQ-to-AQ bridge that just moves messages between queuing systems. We use VB to pull messages out of MQ and issue SQL to get it into the database. HTH Tony Aponte -Original Message- From: YTTRI Lisa [mailto:[EMAIL PROTECTED]]

Re: SQL Tuning

Greg Moore wrote: That's a great SQL tuning presentation, but I don't follow what he says in slide #91: --- No WHERE clause with an ORDER BY Often a screen will return rows with a predefined order, e.g., ORDER BY NAME. The user is expected to

Upgrade 8.0.5 to 8.1.6

A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6 by using export/import. This will probably work, but wouldn't it be easier to just do a cold backup and open them using the COMPATIBLE parameter in the 8.1.6 environment? Is there any downside to using export/import? (ie. will it

What?! Re: How to Drop a Table

Could someone explain why, after dropping a tablespace, you could use DBA Studio to successfully drop tables that are already gone? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

ORA-600-[2845] on Solaris 8 with ORA 7.3.4.5

On Extracting on Solaris 2.8 the Cold Backup of a Database existing in Solaris 2.6 for Oracle ver 7.3.4.5 ORA-00600: internal error code, arguments: [2845], [0], [512], [22], [], [], [], [] NOTE - The Database was working in a healthy condition on Solaris 2.6 for a Number of Months Prior to

Re: PL/SQL, UTL FILE dynamic read v$parameter

utl_file_dir contains a list of valid directories, not just a single directory. The first argument for UTL_FILE.FOPEN needs to be a specific directory that is included in that list. Venkat Somusetty NWK15 2730 x13565 Phone 510-936-3565 Email: [EMAIL PROTECTED] -- Please see the official

Re: What?! Re: How to Drop a Table

On Tuesday 20 November 2001 14:35, Greg Moore wrote: Could someone explain why, after dropping a tablespace, you could use DBA Studio to successfully drop tables that are already gone? You can't. Had you refreshed the view in DBA Studio the tables would no longer appear. Jared -- Please see

RE: applying patch 2032040 to Oracle Purchasing

Matt, I think you should get to read the 'Maintaining Oracle Applications' manual - all the ad utilities are described therein. My understanding is that the install progress is recorded in the FND_INSTALL table and a restart will look up this and decipher what else needs to be done. As far as

  1   2   >