Re: db links...

Hi, Create {public} database link LINK connect to remote_db_username identified by remote_db_username_password using 'connect_string_as_found_in_tnsnames_on_machine_where_you_create_database_link'; There may be some issues with global name settings that may force you to name the database link

Re: GETTING FIRST 250 CHARACTERS FROM A LONG DATATYPE

Hi, In SQL*Plus set long 250 Jack Mark Liggayu

Re: db links...

Hi saurabh, There are two types of database links. Explict database link the syntax is :- CREATE DATABASE LINK db link name CONNECT USING user_name identified by passwd USING connect_string; Default database link the syntax is :- CREATE DATABASE LINK db link name CONNECT USING current_user USING

Re: db links...

Creating db link is pretty easy. This can be done easily by reading the documentation. On the other hand, think carefully to what you want to do. What do you want to access and who will access it. I've seen many clients not knowing who was accessing what because they have grant everything to

RE: how to browsed thru archives of this list

Hi Raja, There are two ways people do this - personally, I keep an archive of all Lyris mail through Look-Out archiving off any mail that is older than 3 days old, every day to a Personal File on my HD. If I have a specific question, I *usually* (not always :) try to import any mail from the

DB on NT

Hi, I' hav to build up foolowing matrix DB Size .. Operating system NT Sun Solaris AIX ... Has anyone a similar matrix to share? Especially I'm interested in the size for NT. I know there was a saying - put no database larger than 1 GB on a NT machine. Is this still

RE: query prob

thanks a lot.. one more thing...how to get the value of return key using sql.. i mean using gui data is entered and the user used enter key for next line so how to get that Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes.

can i place online redologs with oracle engine ?

list, i cannot spare a separate drive for the redologs, can i place the online logs with the same drive as the solaris + oracle engine ? (m,y solaris and oralce are also on the same drive) TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

How can I unsubscribe thislist?

Can anyone tell me how to unsubscribe from this list? Roland Sköldblom -- 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

Re: db links...

thanks a lot. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 1:20 PM Hi, Create {public} database link LINK connect to

RE: CERT and Oracle

It was also reported by the SANS institute --29 June 2001 Oracle8i Database Buffer Overflow Vulnerability Security experts found and disclosed a pair of vulnerabilities in the standard and enterprise editions of Oracle8i database. The Transport Network Substrate (TNS) Listener has a buffer

Schema organization

Hi all, I'm a fan of having the processing done by a user different than the owner of the data. Am I alone ? For example, we're on a datawarehouse system where the data owner is DWH. The etl tool repository owner is TOOL_POWERMART and the reporting tool repository owner is TOOL_BOWEBI. The etl

RE: GETTING FIRST 250 CHARACTERS FROM A LONG DATATYPE

Stephane, You could write a plsql by defiining a variable with 32K (like fetch_log_valuevarchar2(32760)) You could fetch the long data type column value into fetch_long_value variable after opening the cursor. After that you can use substr on this variable. Baskar -Original

test

test Best Regards Sinardy *** CONFIDENTIALITY CAUTION This message and its attachments (“Message”) are intended only for the use of the individual or entity to whom it is addressed,

RE: GETTING FIRST 250 CHARACTERS FROM A LONG DATATYPE

Mark, You could write a plsql by defiining a variable with 32K (like fetch_log_valuevarchar2(32760)) You could fetch the long data type column value into fetch_long_value variable after opening the cursor. After that you can use substr on this variable. Baskar -Original Message-

RE: DB on NT

Hi, Regarding the issue of databases larger than 1GB on NT, could someone please explain this to me, as I was not aware of this 'saying'. Thanks in advance, Steven H. -Original Message- Antje Sent: 05 July 2001 10:51 To: Multiple recipients of list ORACLE-L Hi, I' hav to build up

D2k Reports

Hi, Is it possible to save the Bitmap Reports output in .txt or .pdf or .doc like files, if its so pls tell me how to do it. Thank you so much Regards GSK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Senthil Ganapathi INET: [EMAIL PROTECTED] Fat City Network

Re: Schema organization

Stephane, I'm sure they would prefer to operate as the schema owner but to me it's sloppy practice. You're right; create the objects as DWH and grant the necessary permissions to the application users. That way only the schema owner has 'admin' rights (create, drop, alter etc.). If they can't

RE: How can I unsubscribe thislist?

Roland You can find this information, right at the end of your email: Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: can i place online redologs with oracle engine ?

off course -Original Message- Sent: Thursday, 5 July 2001 5:16 PM To: Multiple recipients of list ORACLE-L list, i cannot spare a separate drive for the redologs, can i place the online logs with the same drive as the solaris + oracle engine ? (m,y solaris and oralce are also

Re: Schema organization

i try to play by the same rule as you. but if i can't then i put the ddl triggers on the tables owned by the schema owner, which keeps at least the strucutures from being altered. joe paquette stephane wrote: Hi all, I'm a fan of having the processing done by a user different than the

RE: DB on NT

Me neither. I've had database 50-70G in size on NT. (Which, in the grand scale of things isn't terribly large, but it's my personal experience and sufficient for this example). Compaq ProLiant servers, Compaq RAID controllers and storage arrays. Very nice equipment, rock solid and very fast. So

RE: D2k Reports

Senthil, In the parameters palette window, you have two options - Destination Type and Mode. Both options allow you to produce the report in other than bitmap format. There is an options CHAR type format which is character-based. hope this helps. Tom Mercadante Oracle Certified Professional

RE: Online backup script..........

Thanks svend, BFN. -Original Message- Jensen Sent: Thursday, July 05, 2001 12:51 AM To: Multiple recipients of list ORACLE-L Here are two files, a NT cmd and a sql script that do hot backup of archivelog databases. Remember to configure the scripts and ajust to your enviroment

RE: DB on NT

Antje I know there was a saying - put no database larger than 1 GB on a NT machine. The above is nonsense. I have a database that is 200G on NT. I know of no limit regarding database size on NT. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July

RE: DB on NT

Guy, rantDon't even get me started on Unix, which sucks. Rebooting if you need more file descriptors?! Or shared memory? All operating systems suck. Apart from maybe VMS./rant Isn't saying all operating systems suck a bit harsh? :) Personally, I think they all have their challenges, but they

RE: Online backup script..........

(robert) - you ARE the weakest link! goodbye! :) that's what I call immediate justice. -Original Message- Sent: Wednesday, July 04, 2001 7:36 PM To: Multiple recipients of list ORACLE-L Robert, After going through the archives I find that in the past year you have posted 14 times

RE: Online backup script..........

Jared Still wrote: Many folks find the acronym RTFM to be sufficient, as it can also mean 'Read The Fine Manual' Do you mean there is another meaning to RTFM :o) Dave -Original Message- Sent: Wednesday, July 04, 2001 6:01 PM To: Multiple recipients of list ORACLE-L Isn't

RE: how to browsed thru archives of this list

Mark, 1. What do you mean by Look-Out archiving? Do you mean to say that you save the email as File Save into your hard drive each and every mail, that is the ones you are interested in (if this is the case, well I will like to save all emails basically, you never know what you are reading

RE: DB on NT

Perhaps it is confusion with filesize and then it is a whole different ball game and not only for NT but some older unixes and other OS's as well. and then we can start the arguments for using raw or not using raw for files under unix. Peter At 10:45 PM 5/07/2001, you wrote: Antje I know

RE: Script to find space bound objects

Title: RE: Script to find space bound objects This is my two pence select a.tablespace_name,a.segment_name,a.segment_type,a.su ,b.sf from (select tablespace_name,segment_name,segment_type,next_extent/(1024*1024) su from dba_segments) a, (select tablespace_name,max(bytes/(1024*1024)) sf

Re:DBMS_ALERT

I believe you'll need to be more specific. Using an alert is fairly simple, but sometimes does not get the desired results. Dick Goulet Reply Separator Author: Pulikkol Kumar [EMAIL PROTECTED] Date: 7/4/2001 12:35 AM Hi lists Any one can help me

Re:Schema organization

Stéphane, Your not alone. I like having one schema that owns all of the objects and a second or more that manipulate the data therein. The reason is that many times the passwords for the other user accounts get hard coded into software making them almost impossible to change. This way if

RE: Online backup script..........

hahahah, roflmao, thats hilarious, my co-workers are wondering whats so funny. joe [EMAIL PROTECTED] 07/05/01 08:51AM (robert) - you ARE the weakest link! goodbye! :)that's what I call immediate justice.-Original Message-Sent: Wednesday, July 04, 2001 7:36 PMTo: Multiple

Re:can i place online redologs with oracle engine ?

Rahul, You can put them just about anywhere you want, but since they tend to be a high IO item you may end up paying a price. Dick Goulet Reply Separator Author: Rahul [EMAIL PROTECTED] Date: 7/5/2001 1:16 AM list, i cannot spare a separate

RUPD$_

Good Thursday morning! I have a nagging question that I can find only sketchy documentation on. I have been working with Materialized Views and their associated logs and have been trying to figure out what the RUPD$_tablename structures are for. I have watched those tables during incremental

FYI - Oracle 8i contains buffer overflow in TNS listener

Hi, Please check this Thanks Muthu --- CERT Advisory CA-2001-16 Oracle 8i contains buffer overflow in TNS listener Original release date: July 03, 2001 Last revised: -- Source: CERT/CC A complete revision history is

RE: Online backup script..........

Title: RE: Online backup script.. Woo Hoo! Jared opened up a can on you Robert! c'ya! --Chris [EMAIL PROTECTED] -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 04, 2001 7:36 PM To: Multiple recipients of list ORACLE-L Subject: Re:

RE: how to browsed thru archives of this list

1) Sorry about that - I was using a funny name for MS Outlook. Within Outlook, you have an option called archiving, which I have set up as follows: 1) Create a rule that moves all mail received in my Inbox from [EMAIL PROTECTED] to afolder called Lyris automatically

816/817 and JDBC Driver

Hi, following question on NT. I need to install 817 JDBC-Driver as I neet JDBC2 compliance. I just have a Oracle 8.1.6 database and installed SybaseToOracleWorkbench817. I copied JDBC-Driver in 8.1.7 home and was wondering if it is sufficient to have the 8.1.7 Home and OCI of 816 is used or do I

RE: Schema organization

A couple of other reasons for this approach: When you create a DAD in Oracle Application Server, you can choose to store the password in the config file. On version 3.02 it is in unencrypted form and is optional. On 4.x it's encrypted and mandatory (unless you cheat and remove the password

UNIX vs. 2000... check out what the Gartner Group thinks about M$ latest offering and how they compare

I don't want to start another discussion on this topic, I just thought that this was a good article. It appears that Unix is still king for VLDB or mission critical apps... Frank - DPRO-89898 Mary Hubley, Mary Ann

Re: Which RBS have active transactions?

Terrian, Tom wrote: Does anyone know of a way to determine which RBS extents have active transactions? Specifically: select a.segment_name, a.bytes, a.extents, c.xacts from dba_segments a, dba_rollback_segs b, v$rollstat c where a.segment_type = 'ROLLBACK'

Re: Schema organization

paquette stephane wrote: Hi all, I'm a fan of having the processing done by a user different than the owner of the data. Am I alone ? For example, we're on a datawarehouse system where the data owner is DWH. The etl tool repository owner is TOOL_POWERMART and the reporting tool

Re: how to browsed thru archives of this list

On Thursday 05 July 2001 07:41, Mark Leith wrote: folder called Lyris automatically when any mail comes in. (This keeps the lyris mailseparate from any other business mail, for ease of reading) Mark, You seem to be under the impression that we are still using Lyris mail software. I

Re: RUPD$_ (long)

April, How's Amarillo lately? ;-) The only useful thing I found was on metalink forum (I'm sure you've seen it) pasted below. Looks like a special log for UPDATABLE SNAPSHOTS, which would make sense in the context of 2 way replication. Scott Shafer San Antonio, TX

RE: how to browsed thru archives of this list

Nope, under no such disillusions :) It's just that I have been on the list since way back when, and have always called it the Lyris List. I suppose I could call it ORACLE-L, but why change what I already have set up? :) I was just describing *my* set-up. I suppose you could call the folders

RE: Which RBS have active transactions?

Thanks, I was able to write a script that gets me most of what I want: select a.segment_name, b.start_uext ACTIVE EXENT NUMBER, b.used_ublk USED RBS BLOCKS from dba_rollback_segs a, v$transaction b where a.segment_id = b.xidusn order by

RE: Wildly OT. Made me laugh.

*excellent* !!! thanks! -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 04, 2001 7:31 AMTo: Multiple recipients of list ORACLE-LSubject: Wildly OT. Made me laugh. For the UNIX people out there Unix csh/sh commands:

RE: DB on NT

ALso, what does 1GB actually mean? That much data, if you dumped it all out into a CSV file? A 1GB tablespace to hold all the data (and how is that tablespace organized)? 1GB being the sum of the sizes of all the datafiles? So, even if there were such a saying, it would be meaningless. What I

Where is the lock?

On of our applications is reporting a problem trying to access on a record in a table. The application is reporting that a transaction is reserved for update. The app in question hung whilst working on the record a few days ago. I'm not convinced that this is an Oracle problem, i.e. a row lock

RE: Schema organization

So what your DDL triggers are doing. And if they do not allow DDL to work how you can execute DDL - disabling these triggers? Alex Hillman -Original Message- Sent: Thursday, July 05, 2001 8:00 AM To: Multiple recipients of list ORACLE-L i try to play by the same rule as you. but if i

Re: ALTER SYNONYM?

Well, here's what I'm trying to do. I've got a pile of tables that are read-only tables that are downloaded periodically (approximately daily) from another system. They get slurped into our database via sqlloader. A previous incarnation of this process had the setup run sqlloader on the data

RE: urgent..! how to combining 2 querries...

-Original Message- Sent: Wednesday, July 04, 2001 2:53 PM To: '[EMAIL PROTECTED]' I think you need this comp sum of nfrags totsiz avasiz on report break on report col tsname format a16 justify c heading 'Tablespace' col nfrags format 999,990 justify c heading 'Free|Frags'

RE: RUPD$_ (long)

Amarillo is still beautiful.. although the natives don't seem to share my enthusiasm. Yeah, I found this... I was just hoping for... more. I can find considerable stuff on mlog$_ tables, but I'm still digging on this one. I love the 'documenation' on some of these 'features'. Thanks April

RE: DB on NT

I tend to leave out the sid in a datafile name, saves me from having to rename it, if i'm doing the transportable tablespace ordeal. joe [EMAIL PROTECTED] 07/05/01 12:03PM ALso, what does "1GB" actually mean? That much data, if you dumped itall out into a CSV file? A 1GB tablespace to

RE: Schema organization

yeppers, if you want to prevent ddl on tables when you are required to give out the schema owner password, you put those triggers on all of the objects. This assumes the user logging does NOT have alter any trigger. The triggers are owned by a separate userid and look like this(besides you

Tracing Events - Anybody have a list of the Events?

Morning Folks - Hope those of you in the US had a safe and happy 4th - for those of you who didn't celebrate this particular holiday, hope your day was also safe and happy ( every day should be safe and happy!). I'm trying to set up some tracing for various events/levels. Not using OEM. In

Mac OS X client for Oracle coming?

This is from www.gmsv.com http://www.gmsv.com from yesterday. Oracle has embarked on an effort to develop client software that will connect Oracle database applications to workstations running Apple's new Mac OS X operating system

RE: 11 disks to build a DB, suggestions

Diego, I think log02 is not a redundant log01, I'm pretty sure it's the second redo log group, without which it will be pretty difficult to run the database :-). Maybe Rahul shouldn't delete it. Yosi -Original Message- From: Diego Cutrone [mailto:[EMAIL PROTECTED]] Sent: Tuesday,

Re: Tracing Events - Anybody have a list of the Events?

Look near the end (~70% through) of the $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events. This is about all I could find. Anyone else? Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: Morning Folks - Hope those of you in the US had a safe and happy 4th - for

RE: Online backup script..........

Now THAT is both useful AND entertaining! -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 04, 2001 7:36 PM To: Multiple recipients of list ORACLE-L Subject: Re: Online backup script.. Robert, After going through the archives I

RE: Tracing Events - Anybody have a list of the Events?

All the events are there in $ORACLE_HOME/rdbms/mesg/oraus.msg The ones you're interested in are the ones above 1. Regards, Waleed -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 12:11 PM To: Multiple recipients of list ORACLE-L Morning Folks - Hope

RE: Online backup script..........

Amen and Bravo, Jared. -Original Message- Sent: Thursday, July 05, 2001 12:46 PM To: Multiple recipients of list ORACLE-L Now THAT is both useful AND entertaining! -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 04, 2001 7:36 PM To:

RE: ALTER SYNONYM?

Hi Rick, How about creating a private synonym for FOO_A and a public synonym for FOO_B. When you drop the private synonym, the public synonym takes effect immediately, and when FOO_A is ready for usage again, you can create a new private synonym. That way there's always a table available. Just

Change Manager problem

Has anyone seen this? Change Manager (OEM 2.2.) on my machine takes a snapshot of Oracle 7.3. databases all right, but when I try to compare this baseline against an existing 8.1.7. database (or a baseline of same), Change Manager does not detect the tablespaces, views, tables, triggers from the

OT: Ari and his company have been noted in InfoWorld...

Ari and his company have been noted in InfoWorld... EPHRAIM SCHWARTZ Wireless World InfoWorld.com Thursday, July 5, 2001 REDUCING THE COST OF DBAS Posted at

Re: Tracing Events - Anybody have a list of the Events?

Very cool, Thank You. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Scott Shafer

Re: OT: Ari and his company have been noted in InfoWorld...

If only it were this simple: ..quantify the amount of time and money their companies would save if their DBAs.could remotely... remove from the database a user who is running a command that is holding up the system. David A. Barbour Oracle DBA, OCP AISD 512-414-1002

RE: ALTER SYNONYM?

Rick, If your current process works for you, that's great! My only thought was that, since you are already sqlloading the data, why not right a PL/SQL procedure that would process the transactions into the existing table. For example, read a record from the sqlloader table, look for a matching

RE: Tracing Events - Anybody have a list of the Events?

Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 2:07 PM To: Multiple

How to precreate tables for migration?

So, We're taking the leap from 8.0.6 to 8.1.7. For various reasons, we will be using the export/import method of migration. Since I'll have the DB all to myself for the weekend, I want to also partition most of our larger tables (1M-7M rows each -- it's not a huge DB) in the migration. My

RE: Tracing Events - Anybody have a list of the Events?

msG -Original Message- Sent: Thursday, July 05, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi -Original

Re[2]: OT: Ari and his company have been noted in InfoWorld.

Where I am the amount is zero as we all have remote access from home already. What one can quantify is the amount of extra $ it costs for a VPN dial-up line vs. the wireless connectivity this monster requires. Now that comes to something (what I am not privy to), so good-bye PocketDBA. Dick

InterMedia Gurus

Any one you guys/dolls out there who are really using InterMedia, this one is for you Have you come across a good, single user scanner/OCR combo for putting hardcopy into a db under InterMedia? I have a bunch of dox i'd like to put on a CD or DVD, but want very high quality OCR and don't

Re: How to precreate tables for migration?

As I impose order on our servers, (moving from project-managed to dba-managed db's) I perform this sort of task for individual schemas. The short form is the same as yours except: 3.5) create schemas where tables or tablespace assignments will change. 4.5) create tables that are to have storage

RE: Tracing Events - Anybody have a list of the Events?

Only in UNIX -Original Message- Sent: Thursday, July 05, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi

Re: How to precreate tables for migration?

for precreatng the users, pull the create users statements out of the .dmp file. joe [EMAIL PROTECTED] 07/05/01 02:35PM So,We're taking the leap from 8.0.6 to 8.1.7. For various reasons, we will beusing the export/import method of migration.Since I'll have the DB all to myself for the

Re: Tracing Events - Anybody have a list of the Events?

Try oraus.msg (if it exists). Sorry I don't have an NT install (woohoo! ;-) to check on... Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0

OT: Just chatter about Wireless costs and PocketDBA

While i don't shared DG's feelings about the size and resource consumption of the PocketDBA, I do share his feelings about the cost of the wireless access. Around here, Ricochet for the Palm PDA runs about 50$ a month or so. What bullsh*t! When I get wireless for an additional 10$ a month,

RE: Re[2]: OT: Ari and his company have been noted in InfoWorld.

Well, we have remote access from home too, but it might be convenient to be able to do this stuff while I'm running from a grizzly in the Absarokas. That way I wouldn't have to hang around the house all weekend waiting for a call that might never come. Of course it's a moot point for us since

RE: Tracing Events - Anybody have a list of the Events?

Yeah, thanx all. It seems us poor NT users can't see the events list. We only rate an MSB file, not an MSG file. -Original Message- From: Scott Shafer [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 3:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Tracing

Re[4]: OT: Ari and his company have been noted in InfoWorld.

Thursday, July 05, 2001, 3:40:31 PM, Walt Weaver wrote: WW Well, we have remote access from home too, but it might be convenient to be WW able to do this stuff while I'm running from a grizzly in the Absarokas. I hope I never have the opportunity to run from a grizzly. I once bumped (not

* Oracle DBA Needed in Phoenix..

If you're interested in a great opportunity, then consider this position in Phoenix, AZ with a leading company that needs an Oracle DBA to join its' I.T. staff. We would like to submit someone who is a renter and who is interested in Phoenix but has not applied to Phoenix companies and is not

RE: Re[2]: OT: Ari and his company have been noted in InfoWorld.

We did something similar to this 4 years ago using the 2 way pagers, email, home grown algorithm similar to secure key(give me a number and I'll check to see if it's the correct sequence), and a heck of a lot of PERL programming. So IF WE HAD COVERAGE on the 2-way pager(RIM pager using

SQL ERROR--Nebulous definition

I have some simple procedures in a DEV instance that run just fine (e.g. enable_constraints, drop_table, insert_data). When I import them into the PROD instance, they won't compile stating that PROCEDURE ROSTERDBA.DROP_TABLE On line: 7 PLS-00201: identifier 'SYS.DBMS_SQL' must be declared. I am

RE: How to precreate tables for migration?

Hey Don! GREAT info! I'm wiping out my test DB right now to try it out. I already have the scripts to create the TSs (I've learned a little in three years), so that's no biggie. I'll letcha know what happens. THANKS! :) Rich Jesse System/Database Administrator

Re: ALTER SYNONYM?

Rick Osterberg wrote: Well, here's what I'm trying to do. I've got a pile of tables that are read-only tables that are downloaded periodically (approximately daily) from another system. They get slurped into our database via sqlloader. A previous incarnation of this process had the

Re:OT: Just chatter about Wireless costs and PocketDBA

Ross, What I was talking about is the added expense of wireless connectivity for a PDA. Personally I don't own a PDA and have no desire to do so. Dick Goulet Reply Separator Author: Mohan; Ross [EMAIL PROTECTED] Date: 7/5/2001 11:19 AM While

Sorry---I figured it out.....FW: SQL ERROR--Nebulous definition

Sorry for wasting the bandwidth lc -Original Message- Sent: Thursday, July 05, 2001 4:00 PM To: ORACLE-L@fatcity. com Cc: Lisa R Clary I have some simple procedures in a DEV instance that run just fine (e.g. enable_constraints, drop_table, insert_data). When I import them into the

Strange explain plan

Hi all. I'm having problems with the following query: select a1.MBR_TYP_CDE MBR_TYP_CDE, (COUNT ( DISTINCT a1.NOVS_NTWRK_MBR_KYD )) from MDSS_STAR.NOVUS_NETWRK_MBR_D a1 group by a1.MBR_TYP_CDE It fails with ora-06000 (parameter 15851). I have noticed that if I created the new table

RE: OT: Ari and his company have been noted in InfoWorld.

I for one think Ari and his company need to be commended. In the future you and I will be capable of admin'ing and monitoring multiple databases via handhelds. Larger consulting companies will likely have teams of DBA's that are responsible for large pools of databases. New databases will be

RE: Re[2]: OT: Ari and his company have been noted in InfoWorld.

and 3) if you are working on that stuff while running from a grizzly you are either planning on getting killed or a REALLY fast runner able to concentrate on many things at once in the face of death From: Weaver, Walt [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of

RE: SQL ERROR--Nebulous definition

Title: RE: SQL ERROR--Nebulous definition It's saying that execute permissions on sys.dbms_sql must be granted to ROSTERDBA Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry

Re: * Oracle DBA Needed in Phoenix..

Thursday, July 05, 2001, 4:15:20 PM, you wrote: O We would like to submit someone who is a renter and who is interested O in Phoenix but has not applied to Phoenix companies and is not working with O other recruiters for Phoenix companies. Now why in the world would any of this matter? Best

can/do indexes chain?

I've been asked to create an index which combines two fields, date location. For reasons I don't really want to explain, we need/desire this index to be in the order of date, location. The minor gotcha is that while location will be populated at the time the record is created, the date field is

RE: OT: Just chatter about Wireless costs and PocketDBA

But you can play games on them. I actually used to think the same way until the company agreed to by me one. Since I use Outlook so much they are actually quite nice to have. Now, instead of carrying a day timer I carry a Palm. Makes life easier for me. Now I am going to go get the software

RE: * Oracle DBA Needed in Phoenix..

Ditto. This 'renter' thing sounds like some sort of thinly veiled discrimination. -Original Message- Sent: Thursday, July 05, 2001 2:41 PM To: Multiple recipients of list ORACLE-L Thursday, July 05, 2001, 4:15:20 PM, you wrote: O We would like to submit someone who is a renter and who

Re: * Oracle DBA Needed in Phoenix..

On 07/05/2001 3:41:08 PM, Jonathan Gennick is quoted as saying: . . . .|Thursday, July 05, 2001, 4:15:20 PM, you wrote: . . . .|O We would like to submit someone who is a renter and who is interested . . . .|O in Phoenix but has not applied to Phoenix companies and is not working with . . .

RE: OT: Ari and his company have been noted in InfoWorld.

I wonder if a similar thought was echoed in 1991? Maybe all of the DBAs that were former DB2, etc DBAs could offer some war stories here. It's funny that databases have become more cumbersome to manage, not easier IMHO. DBAs have to understand more technologies that are outside the RDBMS box

  1   2   >