Does the table inventory.company exist?
Abdul Aleem
dmitTo: Multiple recipients
One thing to consider is country codes. I have seen many applications
where two character country codes have been crammed into the STATE_CDS
table. Usually the two character state abbreviation is the primary key,
but that means that some smaller countries end up with abbreviations that
have no
Create a view where you select the case-insensitive columns with
upper(col-name), then create a public synonym on the view. The application
will see the table through the view.
I'm sure that everyone is sending you their version of this:
ttitle off
set pages 40 lines 132
column value heading ''
column sessions_current format 999,999,999 heading '# Currently Logged On'
column sessions_highwater format 999,999,999 heading 'Most # Logged On'
column pusername format a8
I'm assuming that you're creating a 9i database on the new machine when you
install Oracle.
I find it useful to pre-create the tablespaces (and users) on the new
database, rather than let the import do that. This gives you more control
over where datafiles end up and do some clearup on
Not an easy question.
Set up a folder (directory) on the NT server called STUDENTS. Set your
utl_file_dir parameter to that folder. From the server's SERVICES panel,
stop and start the instance (so the parameter will take effect). Under
STUDENTS, create folders for each of your students and
I'm not sure which is best but here are my observations;
Solaris - kernel patches take effect without a re-boot. This is Oracle's
development environment (It'd be a hoot if Oracle developed their software
in a Win95 environment!!).
HP-UX - This used to be the Oracle Corp's production
I've done this in the past:
Install 8.1.7 and create a database (same SID as your current database).
Create the same tablespaces and users as your current database. Export
your old database and import it into your new database. Be sure to use the
same level client software for the export and
It's called a text editor.
Peter.McLarty
@mincom.com To: Multiple recipients of list
I think that he has a much more serious problem than setting the SID. If I
understand the situation the Oracle Service (the instance) is not starting
because the ORACLE_HOME parameter in the registry is messed up (probably as
part of the upgrade).
Try clicking START, PROGRAMS, ORACLE FOR WIN2K
Check and see if your J disk is full. On your Win2k desktop, find the My
Computer icon. Right click and choose explore. Find the J drive and
right click; choose properties. If the disk is full, that's your
problem.
On the other hand, a J drive could be a network mounted drive. If it is,
If your listener.ora file is OK and you've just lost the service then go to
the C: prompt and type LSNRCTL START. This will fail,but it will have
created the service. You can then go start the service and set it up for
autostart from the SERVICES panel on the CONTROL PANEL.
Silly, but it's
Try something like
select a.col1||a.col2, b.col3||b.col4 from table1 a, table2 b
where a.col1||a.col2 = b.col3||b.col4 (+))
WHERE b.col3||b.col4 IS NULL;
I think that works.
gologin.sql
Here's an example from Oracle:
--
-- $Header: /plus/v3/spam/precious/files/ACTIVE/glogin.sql,v 1.6
1995/07/25 02:33:26 cjones Exp $
-- Copyright (c) Oracle Corporation 1988, 1994, 1995. All Rights
Reserved.
--
-- SQL*Plus Global Login startup file.
--
-- This is the global
Put a blank line at the end of your script. I don't know why it does that
but that's the fix.
Farnsworth,
An idle instance is an instance with no mounted database. If the service
is autostart and is otherwise correctly configured, Oracle will start the
instance and mount the database. You should not see this message.
I got an email from them asking to fill out a skills matrix. Never heard
anything further.
Koivu, Lisa
I'd also add a date/time stamp and the Oracle userid of the deleter. Heck,
why not also journal inserts and updates? Or maybe you can get all this
from logminer.
Kevin Lange
Now'a'days you have to go into the SETUP during boot and set 'RUN SYSTEM
FASTER' in the CMOS.
DENNIS
Sounds like a database issue, so it's not OT.
--
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
I try to keep the total SGAs of all instances below 50% of RAM for Windowz
machines, but maybe that's another urban legend. WinNT tried to keep 95%
of its RAM empty. It thinks that it's a heavy lifting operating system
with thousands of users clamoring for its attention (sort of like most IT
Different names for the same thing. Snapshots is being phased out and the
new terminology is materialized views.
Todd Carlson
My favorite (or at least the one that annoys me the most) is Every
object in the INITIAL extension. After that would be OFA where the DBA
doesn't get the difference between an LV and a physical drive.
The best argument is that you have the hardware and software on-site for
disaster recovery.
It's not a failover situation but it does mean that production would be
down for hours instead of days.
Reduce the number of DB_BUFFERS. Unless my eyes deceive me, if you have a
2k block size, then you're trying to allocate 1.2G of SGA just for the
DB_BUFFERS.
On an Intel system (I assume W2K), I wouldn't try to allocate more than 1/2
the physical RAM for the total SGA. Windows will still swap
#7 is right on the nose. I can't count the times that a developer has told
me that another index will solve all his performance problems.
Jamadagni,
My bad. I didn't notice that he was doing a select * from v$sga and
thought that it was the init.ora parameters.
My comments on the SGA size were based on WinNT 4.0. I assume, from your
comments, that W2K is better about not swapping the RAM out to disk.
I need to compare identical databases across two instances. I've set up
a MID instance to do the heavy lifting and not impact our production. But
this particular form of querying via link A with a sub-query via link B
kills the session.
middleman@mid SELECT ADR_DTF_ID FROM ADDRESSES@IHP WHERE
I'd like to add vote to the paper that Mr. Pannequin recommended. To quote
from the summary:
. If we had used the standard export/import' method we estimated the whole
move would have taken at least 12 days, but using the techniques we
developed, the move was done in 18 HOURS. They were moving
I've never tired this but could you ALTER DATABASE BACKUP CONTROLFILE TO
TRACE and then use that for a
CREATE CONTROLFILE?
If you don't have any data missing from your datafiles and all you need to
do is make your controlfiles current, this should do it.
How was the service created? Is it set to automatically start?
Jared.Still
@radisys.com To:
OK. That does it!
My first experience with computers involved pushing one up against the wall
to block the cooling ducts so that it would overhead and it could be beaten
at tic-tac-toe. Theoretically impossible, but the amazing thing about
idiots is that they're so ingenious.
A more
rem
rem file: mapper.sql
rem location: $HOME/sql
rem parameters: the tablespace name being mapped
rem
rem Sample invocation:
rem @mapper SYSTEM
rem
rem This script generates a mapping of the space usage
rem (free space vs used) in a tablespace. It graphically
rem shows segment and free space
1. Run, don't walk, to monster.com.
2. Update and print resume
3. Enjoy vacation (hopefully brief)
Nothing good is going to come of the warehouse
Don dondealy
On UTL_FILE, I've never had much luck using network mounted files.
Igor Neyman
ineyman
What's your ORACLE_SID set to? Did you add your new database to your
listener? You didn't say how you created the second database.
DBAtracker
Try putting the word
spatial
in double quotes.
--
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
Obviously you don't know Boeing Travel. The way it works is:
8 hours flying time to Hawaii.
230 hours layover (with per diem).
12 hours flying time to Sydney.
And if you schedule your flight to Hawaii for wheels up before 6am, then
you get a full per-diem for that day too.
My comments are interleaved:
Lissa
Lieberum To: Multiple recipients of list
I've been using PKZip GUI for years and never have had a problem.
Jack C.
Applewhite To:
Only when they don't know the words.
Mohan, Ross
MohanR To: Multiple recipients of
Where the business use of the data is such that the applications' selects
can be satisfied by querying a known number of partitions (less than all
partitions). Also where data can be archived partition-wise. Generally
this means time sensitive data. I don't see much benefit to partitioning
I've seen this done also on a Java project. My understanding was that it
had to do more with the way an object oriented programmer's mind worked
than with any code efficiency.
I agree with Ixora's criticism of SAME; however, I think that Oracle is
justified in offering a solution that will provide adequate performance for
those DBA's who don't understand RAID. That some DBA's don't understand
RAID is evidenced by the inevitable response to read up on OFA and the 22
So what is the basis for the case by case judgement. I'm not being flip -
I really want to know.
From the discussion so far it appears that the pros for PL/SQL procedures
are:
Uniform access method to the database for all applications
Processing done on the more robust server machine
TO get around the 8.x-7.x database link I wrote:
/*
produces output similar to the 'desc' command over a db_link
takes two parameters
1. the table to be described
2. the name of the db_link (with @ sign)
*/
-- t. day 9-25-01
set verify off
select column_name, data_type,
Just a guess, but have you checked the firewall settings?
Rusnak,
George A. To:
SELECT * FROM (SELECT VALUES FROM TABLE ORDER BY VALUES) ROWNUM 101;
Deen Dayal
ddayal
Oracle 8.1.6, using Net8, wants me to name my db_link the same as the
database that it's linking to.
I don't want to.
Tried using a synonym but that didn't work.
Tried using create database link linkname connect to userid identified by
password
using ' (DESCRIPTION =(ADDRESS_LIST =
I knew that there was a simple answer but was having a senior moment. The
error messages didn't help any either.
I can't help but ask myself why they made TRUE the default.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
When I connected I got:
OWS-05101: Execution failed due to Oracle error -6550
Oops! Maybe they have the wrong character set.
Grabowy,
Nope. I don't. It was over a year ago so (being wildly optimistic) I
expect that flaw was fixed.
Kimberly
I don't remember export supporting queries. Why don't you create a temp
table or tables, eg. create table t_linemto as select * from linemto where
PROJ_CODE='CF-804', and then export the temp tables?
I won't comment on what I think about Oracle as a company. However, the
fact that Beta was technically superior to VHS and sold at a cheaper price
did not save it from a series of bad marketing decisions. Today people
don't even remember that VCR's used to come in two separate and
incompatible
I agree with the column naming comments. I would find it hard to
over-emphasize the need for a column naming convention that allows you to
know what table a column belongs to, whether it's a primary or foreign key,
and ,if it's a foreign key, then what the name of the base table and column
are.
Last Java project that I worked on (about 1 year ago), the Java thin client
was not robust enough to handle more than two or three connections
simultaneously. More than that and the threads got twisted. Client
application would hang waiting for a response from the database. The
database had
I was just the DBA, not the JAVA developer, but --
We had a Database server using JDBC to talk to an application server. The
application was written in Java and used Java thin client to talk to the
client (endusers). The endusers had any Java compliant browser. No
applets (security issues --
Oracle 8.1.6.0
We're trying to recreate our snapshots. We used the syntax 'CREATE
SNAPSHOT'. The snapshots won't refresh. Error message is ORA-12018.
Everyone's gone for Christmas with their office's locked (documentation
inside!) and the internet connection is down. So 'R'ing TFM is out of
There were other problems which were masquerading as a refresh problem.
Merry Christmas and Happy New Year to all.
--
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
As someone else suggested, I have always used the internal drives for
vendor software. I can always re-install it from the original medium.
Other than that, temporary files, downloads, system swap space -- things
that I really don't care if I have a copy of.
I'd guess that the database was shut down with a shutdown abort and smon is
busy recovering.
Sajid Iqbal
This is my whoison.sql - not mine but I don't remember where I got it.
ttitle off
set pages 40 lines 132
column value heading ''
column sessions_current format 999,999,999 heading '# Currently Logged On'
column sessions_highwater format 999,999,999 heading 'Most # Logged On'
column pusername
Use the REUSE option on the CREATE TABLESPACE command.
Ken Janusz
ken.janusz To:
I'm going to be installing Oracle 7.3.4 and 8.1.6 on the same Win2K server
shortly. The 7.3.4 is so that we have an accurate version of the old
database which is being migrated to 8.1.6 (which explains the 8.1.6).
I'll be putting them in different ORACLE_HOMEs and installing 7.3.4 before
8.1.6.
I don't think that size has much to do with it. You can have lots of data
but if it's all in a few tables then it doesn't qualify as a datawarehouse
(IMHO).
My short take on this is that a datawarehouse is a OLTP database with
de-normalized data that supports a DSS application.
--
Please see
I'm not sure that I understand the question. Is it:
A. Under max load the RAID does not perform up to its specs?
or
B. Oracle does not stress the RAID enough for it to reach its max
performance.
If A, then have the RAID vendor fix whatever the problem is.
If B, then good for you. You
It's not an Oracle vs Access problem, it's a UNIX vs Windows problem. UNIX
is case sensitive. Oracle is also when you are talking about literal
strings (as well it should be if you're talking about literals). Vendor
doesn't know how to check for different cases and does shoddy work.
Actually, Oracle uses OPS internally on their e-mail system. For that
reason (Larry likes his mail fresh every morning) the OPS gets patches and
bug fixes with a very high priority. I used to have to install them.
Oracle runs it on HP-UX HA (High Availability). It's expensive but it
performs
There's no point in mirroring control files on the same disk. Control
files should be mirrored across disks. That way, if one disk crashes you
can get a copy of the current control file from another disk (or just drop
that control file from your init.ora file). Control files are small and
have
Let's see if I can remember a summary of our last discussion on this.
RAID 10 (mirror then stripe) is the way to go unless it's a decision
support database (mostly read only) in which case RAID 5 takes fewer
platters.
If you have enough spindles, I personally would treat them as disks and go
Oracle's thoughts on the matter can be found at:
http://technet.oracle.com/deploy/performance/pdf/opt_storage_conf.pdf
Ruth
http://technet.oracle.com/deploy/performance/pdf/opt_storage_conf.pdf
Harvinder
Singh
If they're just renaming the disks where the datafiles reside, then the
backup controlfile is the way to go.
However, if they're renaming the disk where the Oracle Home resides, then
you need to go edit the registry. Be sure and make a backup of the
registry before you start the edit.
Unasked,
OK. Here's what I do in that situation:
Here's the main driver
-- disable foreign keys on parent_table.column
alter table CHILD1 disable constraint FK1;
alter table CHILD2 disable constraint FK2;
--run the detail_update.sql for each pair of values, ie, the current value
and the
-- value that
Double letters, eg., AA, BB
mohammed
bhatti To: Multiple recipients of list
--THANKSGIVING_LOAD.SQL
--T. Day, SAI, 21-NOV-01
--Run on WORLD.UNIVERSE using schema with DEITY role
declare
cursor c_thanksgiving is
select
PERSON_ID /* NOT SSN -- generated by sequence generator
(Jared) */
,RELATION
,CONDITION
from YOUR.LIFE@WORLD where RELATION
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.
Is there an advantage to using multiple mount points even if they're not
multiple disks? Aren't logical vols spread out over multiple physical
disks anyway?
Kimberly
Count your number of single quotes ('). It should be an even number.
Roland.Skoldb
lom
Is there any way to get the next value of a sequence via a db_link.
I tried
select some_seq.nextval from dual@db_link
but it told me the sequence didn't exist. I went to the database where the
sequence exists and, using the userid that is in the db_link, I was able to
get the next value, so
I'm sorry. I thought that you mounted a database and that the instance was
the area in memory (corresponding to the SGA and PGA) that Oracle used. So
what is the instance?
Denham
Try
set serveroutput on size 100
declare
--
V_SP NUMBER(32) := NULL;
V_FB NUMBER(32) := NULL;
V_PF NUMBER(32,2) := NULL;
--
BEGIN
select to_number(value) into V_SP from v$parameter where name
= 'shared_pool_size';
select sum(bytes) into V_FB from v$sgastat where name = 'free memory';
V_PF
My understanding is that the instance is the service. Can you start the
instance without a mounted database?
Andrey
But does she just want the old tablespaces or does she want the tables and
indexes that were in those tablespaces? I don't think that simply
recovering the tablespaces will recover the tablespace contents, though it
is the way to start.
Doesn't Oracle have a recovery tool -- pay big bucks, they
I don't see any reason why George's approach shouldn't work. In fact, he
can skip step 3 and just copy the files to A from their mirrors. If it
doesn't work, you've always got the original disk A to put back in.
Yes, but she said that she everything EXCEPT the system tablespaces. If
this is true then they're SOL, except for Data Unloader.
Randy
I've never used it with a monster query but I do use it's inverse all the
time.
Create table test1 as (select * from test2 where 1=0);
This creates a copy of the structure of the original. Leave off the where
and you also copy the data. Maybe they just want to make explicit that
which is
Simplest way is not to enter the password on the same line with the userid.
If you wait for SQLPlus to prompt you for the password, it doesn't show up
with ps -ef.
On the other hand, doing this in a script is more problematical. Anyone
have any examples?
If you want to find the one's that don't have a match try:
select id from table1
minus
select id from table2;
Roland.Skoldb
Put something like this in your glogin.sql or run it after you log in.
set head off
set termout off
column nombre new_v nombre_basedatos
select name nombre FROM V$DATABASE
/
set sqlprompt 'nombre_basedatos '
set head on
set termout on
We're setting up a development box that will have a number of instances on
it. We won't need any backup, since we can easily re-create the databases
from testing instances.
I'm planning on implementing the disk storage as RAID0 - a single logical
volume stripped across all the drives (6), with
The script below will generate a script that can be used to restore the
userid to its original state.
select 'alter user ' || username || ' identified by values ''' ||
password || || ' default tablespace '
|| default_tablespace ||' temporary tablespace ' || temporary_tablespace ||
' ;'
from
You might ask your programmer to read the manual. However, the first might
be a nice enhancement but it's not currently available.
As for the second, SQL*Loader either inserts into an empty table or appends
to a table with existing data. It doesn't do an implicit update. However,
if your
use the girth -- I'd love to pretend that I knew what this means but
someone might call me on it. What does it mean? Each drive is 36G.
Christopher
Here's a kludged-together work-around. After you do your rare pool
requests, drop the sequence and recreate it starting at MAX(ID)+1. There
is no easier way to reset the sequence number.
SQL declare
2 w_a number := 0;
3 w_b number:= 0;
4 w_c char(10) := null;
5 w_d number := 0;
6 cursor v_c_t is
7 select a,c,b from civ_test;
8 begin
9 for v_c_t_row in v_c_t loop
10 :w_d := w_d + 1;
11 :w_a := 0;
12 :w_c := null:
13 :w_b := 0;
14 :w_a := select c
Thanks. Now all I have to do is coach our SA past the HP auto-config.
--
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
We're getting ORA-12154: TNS:could not resolve service name
I've checked the TNSNAMES.ORA and SQLNET.ORA and they seem OK.
WIN2K. Using the MS Oracle ODBC driver (the Oracle ODBC driver is a no
go).
Anyone have any experience with this?
TIA
--
Please see the official ORACLE-L FAQ:
Set spooling as you need it -
***
set linesize 132 pagesize 66 verify off
ttitle List Grants for User or Role 1 skip 2
column name heading 'Name'
column role heading 'Role'
column tname heading 'Table'
column priv heading 'Privilege'
select
Here's an interesting link:
http://hometown.aol.com/merryeee/ibmstory.htm
However, the story it tells is a little biased. The Hollerith company sold
unit record machines to the Weimar Republic, as well as many other
governments (including the US), for census purposes. My one-time neighbor
in
1 - 100 of 181 matches
Mail list logo