Error-00103 While Creating Type

Hi! When I execute the following code on Oracle 8i release 3 (8.1.7) CREATE OR REPLACE TYPE Test ( Emp_Name VARCHAR2(30), Emp_Desgn VARCHAR2(30), Emp_Addrs VARCHAR2(50) ); It gives error "Type created with compilation errors". The All_Errors view

shell script for ftp

Hi Friends I need the following sollution My Senario. i have archivelog files .these files thru ftp send to another server. I needautomatic shell script.any one know please help me. Apparao.

Seattle- Solid Oracle DBA experience Needed..

Well known company in Seattle Washington is currently seeking a talented Oracle DBA. The ideal candidate will have full life-cycle experience from requirements gathering through logical and physical modeling, design, development, testing, implementation, and tuning. *Requirements: Three to 5

Winston-Salem, NC- Oracle DBA (some DB2 needed)-Manufacturing

Manufacturing Company in the Winston-Salem, North Carolina area has a requirement for an Oracle DBA. The selected candidate must have experience with Oracle databases and some DB2/400, DB2/2 or UDB or Universal DB2 on the AS400 platform (it doesn't have to be heavy). The Oracle will be on a

Re: shell script for ftp

What kind of script. to get the files back ? - Original Message - From: Venkata Apparao N To: Multiple recipients of list ORACLE-L Sent: Saturday, April 07, 2001 9:50 AM Subject: shell script for ftp Hi Friends I need the following sollution My

NT: Re: Win2k Backup

Tavo, The most important thing about backup is - recovery. If you use the ARCServeIT product for creating a (hot/cold) backup set, its likely that you'll want to recover using the ARCServeIT GUI. Have you ever tested restoring from a backup set with their product? My philosophy on this is - the

RE: X$ tables

You might also peruse this area: http://www.oreilly.com/catalog/orinternals/desc.html -Original Message- Sent: Friday, April 06, 2001 2:51 PM To: Multiple recipients of list ORACLE-L Hi ! There is no document about X$tables outside oracle. But Steve Adams has some details in his

Re: Re:Driving table

hi Firstly, can we please keep this online? My opinion (observation!).. in RBO the driving table is the rightmost in CBO it need not be so..cos the optimizer decides the order. can someone confirm the observation regarding CBO? Thanx PS: sorry If i missed this...in some earlier

Oracle DBA

Des Moines, IA firm is looking for a strong Oracle DBA candidate with Discoverer, Express, SQL, SQL*Plus, PL/SQL, Portal, and other skills experience. Salary is open DOE. Excellentcompany with great benefits. Permanent position Send resumes to Richard Vander Laan at [EMAIL PROTECTED].

Re: Recovery from noarchive db corrected

Sinardy, what's your uptime requirement? You're allowed a weekly cold shutdown for backup? what I'm asking is - when you are copying the datafiles to tape, its during a clean, cold shutdown, right? Have you ever tested the recovery portion of your backup/recovery scheme? If your 'copying files

Instance allocated more memory to the shared pool than set by the parameters

Hi, Instance has allocated more memory to the shared pool(~ 20M) than set by parameters (13M). Any ideas why? : SYSTEM@PROD select name, value from v$parameter where name like 'shared_pool%'; Object Name VALUE --

Re: Oracle DBA

kewl, a new person to add to my recruiter killfile :) joe "Richard T. Vander Laan" wrote: Des Moines, IA firm is looking for a strong Oracle DBA candidate with Discoverer, Express, SQL, SQL*Plus, PL/SQL, Portal, and other skills experience. Salary is open DOE. Excellent company with

6 databases/one box/performance issue

We have 6 databases on one HPUX box (not my idea) that has 3GB RAM. In this type of situation, can the total of the 6 databases SGAs add up to 3GB? Are there any special types of calculations that should be done in this type of situation to determine optimal performance sizing for the