Hallo all you DBA's,
Can anyone give me some examples on how to do this:
I want a sqlloader to run, the sqlloader is doing an insert into a table(TABLE1) from
a text file, immediately, after the insert into tthe table, there will be an insert
into another table(TABLE2) with data from TABLE1.
Jared et al,
My understanding could be flawed, but I think that setting 'CONSISTENT=Y'
just adds a 'SET TRANSACTION READ ONLY' to the entire export process and
thus ensures that all subsequent queries read all tables as of the time the
export started. Keep in mind that an export just does a
hi,
HOW to find out the whether a particular user has a execute
permission on package or not.
Regards,
sunil s.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: SUNILSHIVAPPA
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
Hello all of you,
I get the ORA-03113 (end-of-file on communication channel) error when I
execute the initjvm script. This script is needed to use utl_smtp
package. Here is the output I get:
***
ERROR:
ORA-03114: not connected to ORACLE
create or replace java system;
*
ERROR en línea 1:
it doesn't store the number of times it extended but it's easily
derived
# extensions=
(v$datafile.bytes - v$datafile.create_bytes)/sys.filext$.inc
--- Reardon, Bruce (CALBBAY) [EMAIL PROTECTED]
wrote:
Is it possible to determine how many times a file has extended?
I know that
Look in trace files. Probably you are hitting a 4030
error. If this the case, not only shared_pool_size or
java_pool_size are the parameters to be increased.
Also increase java_soft_sessionspace_limit or
java_max_sessionspace_size.
If it isn't a 4030 case, put the event to get the
errorstack of
It's in DBA_TAB_PRIVS.
Dennis
SUNILSHIVAPPA wrote:
hi,
HOW to find out the whether a particular user has a execute
permission on package or not.
Regards,
sunil s.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dennis M. Heisler
INET: [EMAIL
Check out DBA_TAB_PRIVS and look for the EXECUTE privilege.
Jon Walthour
-Original Message-
Sent: Monday, October 01, 2001 5:25 AM
To: Multiple recipients of list ORACLE-L
hi,
HOW to find out the whether a particular user has a execute
permission on package or not.
Regards,
Title: RE: privileges on packages
USER_TAB_PRIVS.
Here is an example:
[EMAIL PROTECTED] create or replace package my_pack is
2 type abc_t is table of number index by binary_integer;
3 p_abc abc_t;
4 p_un varchar2(20);
5 end my_pack;
6 /
Package created.
[EMAIL PROTECTED] show
Hi All,
I am trying for hot backup restore/recovery.
Oracle 8.1.7.0.0 on WIN 2K Server. I am performing
the operations in following order:
1. Put all the tablespaces in backup mode.
2. Copy all the datafiles to backup location.
3. Do end backup for all the tablespaces. Also switch
I am making the assumption here that you are doing
recover database using backup controlfile when you do the backup
In this case, what is happening to you is normal. The controlfile
doesn't know what the last scn is supposed to be, so all you have to do
is cancel the recovery once the last
Hallo all you DBA's,
Can anyone give me some examples on how to do this:
I want a sqlloader to run, the sqlloader is doing an insert into a table(TABLE1) from
a text file, immediately, after the insert into tthe table, there will be an insert
into another table(TABLE2) with data from TABLE1.
Rachel,
You are absolutely right!!
Just after dropping the mail I continued with the tests,
and discovered the same theory.
Thanks a lot for reply.
Best Regards,
Rajesh
-Original Message-
Carmichael
Sent: Monday, October 01, 2001 4:45 PM
To: Multiple recipients of list
Just create a shell script which first calls sqlloader to populate table
1, then calls a sql script to populate table2. Schedule it with a cron
job.
Dennis
[EMAIL PROTECTED] wrote:
Hallo all you DBA's,
Can anyone give me some examples on how to do this:
I want a sqlloader to run,
hi,
i feel u need to give the name of online redo log file after u had applied
all the archived log files, if it's asking for more files.
this should solve ur problem.
pls let me know if it not. i'll try finding other issues also.
saurabh
- Original Message -
To: Multiple recipients of
SQLServer does not have the option for UPDATE TRIGGERS
- AFAIK anyway..
The
Oracle option is UPDATE TRIGGERS, as it does not have a Jet engine - a good
thing..
Regards
Mark
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bunyamin K.
I have some difficult to update ver540 on patch db_update_patche6.sql
Hi DBAs
I am running following script on the system with only one user sys but
everytime it has exclusive lock with system hanging there for ever. I had to
kill the process. Why. System is 8.0.5.1. and aix 4.3.3.1. No
I am working on oracle as a developer and have done some primary level DBA activities and want to go for Oracle DBA certification .Can anyone please suggest som ways how to go about.
Thakyou
Bye
Yes, under CONSISTENT=N they are exported as separate transactions, under
CONSISTENT=Y it is a large single transaction to keep read consistency
across the entire export. Hence the redo generated is similar to a large
report and read consistent views.
Do not criticize someone until you walked a
Try this one, I have found it useful:
-- validate_idx.sql
-- by Brian Peasland
-- Database Administrator
-- Raytheon / EROS Data Center
-- 3 February 2000
--
-- This script will check indexes to find candidates for rebuilding.
-- Run this script in SQL*Plus as a user with SELECT ANY TABLE
--
Can anyone help!!,
I've recently installed Solaris for Intel on a standalone box to have a
dabble with. I want to install the patch 106542-17 so I can then install
Oracle 8.1.6. The standalone machine does not have Internet access, and
when downloading the patch to my PC running NT 4.0 the
I notice this happens when you don't have enough rollback space.
You may want to go through and check back and see what the original error
was.
You may want to increase your SP a little and decrease your JP a little.
Although it is recommended to have SP: 20M JP: 30M for the install, 90M of
I suggest that for the first part, you read the Oracle docs on triggers
and add an after insert trigger on the first table to load the second
table.
As for the timing of when the job runs:
at a unix prompt type
man cronand read the documentation on setting up a crontab file
--- [EMAIL
Title: RE: Sqloader
Also, depending on what version you are on, you can have multiple INTO TABLE statements. See below from the 8.1.7 doco.
Using Multiple INTO TABLE Statements
Multiple INTO TABLE statements allow you to:
Load data into different tables
Extract multiple logical records
List,
Received this in the email today:
Oracle To Retire Oracle8 OCP Track
As of March 31, 2002, the following Oracle OCP exams will
retire:
- Exam 1Z0-401 Oracle8 Database
Hi,
On our Oracle Apps forms server the F45WEB.EXE process never dies after
a user log out. I have read some suggestions of setting a timeout or
setting a heartbeat sensor but each method has small downside. Before
implementing either does anyone else have any suggestions on how to
handle
John,
You're making perfect sense, as that is the way I've
always thought it worked. Based on some previous
threads I read ( don't know if it was this list ) and
ambiguous language in the docs, I'm not sure if it
actually works that way.
Jared
On Monday 01 October 2001 00:50, John Kanagaraj
1. What is the typical ratio of users to licenses in a concurrent licensing scheme?
Oracle no longer has a concurrent user licensing scheme. Its either named user or UPU
(which has also changed to no. of CPUs, I believe)
2. How does Oracle keep track of the licenses?
You can keep
Title: How much data can SQL*Server hold?
Hello everyone,
Any of you using SQL*Server on fairly large databases? If so please email me directly.
I have a consulting company telling me they can run a 500GB+ database on SQL*Server with no problems and I'm pretty skeptical. What's the
solaris can sometimes understand zip -- we have pkware and zip for our
solaris boxes
you can try unzip -h to check
--- Dave Leach [EMAIL PROTECTED] wrote:
Can anyone help!!,
I've recently installed Solaris for Intel on a standalone box to have
a
dabble with. I want to install the patch
Dave,
zip files can be handled on many platforms these days and I'd hope that Intel
Solaris can process them if they're zipping system patches.
Try which unzip to try to locate the executable or look for a man entry.
I can unzip files on Sparc Solaris and AIX so I suspect you won't have a
unzip utility comes preinstalled with solaris. The default directory is /usr/bin
from the prompt type unzip for help.
Rakesh
[EMAIL PROTECTED] 10/01/01 10:55AM
Can anyone help!!,
I've recently installed Solaris for Intel on a standalone box to have a
dabble with. I want to install the patch
Hi, all
I posted an email about insert French characterset
problem days ago. Here is what I got right now: The
db is 817 running on Sun 5.6, and I use a sqlplus 815
running on NT4.0 to access the database.
If I do insert and select from sqlplus client,
everything looks fine:
SQL insert into
Title: RE: Autoextend - how many times has a datafile extended
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
it doesn't store the number of times it extended but it's easily
derived
# extensions=
(v$datafile.bytes -
Title: RE: rollback segments during export
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Just because there is a PK/FK between tables, it does not
mean they will be
exported in the same transaction. And thus, possibly out of sync.
I didn't say there was.
Title: RE: Autoextend - how many times has a datafile extended
Scratch my last comment, after experimenting I see that the autoextend can not be modified for a datafile.
-Original Message-
From: Jacques Kilchoer
What if the autoextend is changed with an alter tablespace
Title: How much data can SQL*Server hold?
I think SQL Server can hold up to 5Mb.
Just kidding, in 6.5 it is 1Tb, in 7.0 It is 1,048,516 TB
32k dbs/server
32gb file size in 6.5, and 4tb file size in 7.0
And a max of 2 billion objects if I remember correctly.
Do not criticize
Think about it this way,
(Session 1)
SET TRANSACTION READ ONLY
Select * from emp;
22 rows selected.
(Session 2)
Delete from emp where dept = 20;
6 rows deleted.
Commit;
Commit complete.
(Session 1)
Select * from emp;
22 rows selected.
Export is the same as any other transaction,
Everyone:
We noticed some weird ORA-600 messages in our of our test databases,
so we ran 'dbv' against them. The database was shut down. Our
SYSTEM tablespace shows 'Undo Segment Corrupt' errors, and I have
two questions about this.
1) Does this mean my SYSTEM rollback segment is hosed?
Does Oracle have a way to do a search across multiple columns/tables for
specific data? I know I can issue a query with a bunch of or statements,
but is there something similar to fulltext searching?
Thanks for the information,
Rick Stephenson
--
Please see the official ORACLE-L FAQ:
Just thought I would ask. How does everyone feel about Oracle Open World
this year. Will attendance be down?
Ron Smith
Database Administrator
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
Fat City
DOJ hits CA with antitrust lawsuit over Platinum buyout
The Department of Justice has hit Computer Associates with an antitrust lawsuit
seeking up to $1.27 million in penalties related to its 1999 purchase of
Platinum Technology. The company quickly denied the charge.
You might want to look into the Intermedia, it has full text search.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
1.27 million isn't much at all.
They will probably talk them down to 500k and just pay it off.
Cheaper than keeping lawyers on it for 3 years.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
There is currently no realistic way you can discover
how many rows are locked when you change the
bitmap-indexed column of a single row. The number
is dependent on blocksize, distribution of data, and
the coincidental overlap of the FROM and TO bitmap
chunks.
The answer could vary from a
Couldn't have happended to a nicer company.
Ken Janusz, CPIM
-Original Message-
Sent: Monday, October 01, 2001 12:16 PM
To: Multiple recipients of list ORACLE-L
DOJ hits CA with antitrust lawsuit over Platinum buyout
The Department of Justice has hit Computer Associates with an
Title: RE: Oracle Open World
I'd be going if I could get work to pay for it.
heck, I'd go if I could get free hotel (and pay the
rest myself).
That being said, the IOUG-A conference in the
spring is a MUCH MUCH better conference (IMHO), and I encourage
all those who can only go to one
I'm still planning on going... but then I have close friends in the
area and will be using the free trip (my company is paying) to visit
them as well.
--- Smith, Ron L. [EMAIL PROTECTED] wrote:
Just thought I would ask. How does everyone feel about Oracle Open
World
this year. Will
Hello...
I am new to Oracle and am migrating a SQL Server database over into Oracle
8.1.7. My problem is this: I can see the database in the migration
workbench, but then can't seem to find it as a database in the Oracle
Administration Assistant for NT. Also, do you need a unique net service
PerlEvangelism
my $dbh = DBI-connect(
'dbi:Oracle:' . $db,
$username, $password,
{ RaiseError = 1, AutoCommit = 0 }
);
die connect failed\n unless $dbh;
my $sql='select * from persons;'
my $sth = dbh-prepare($sql) || die
my $rv = $sth-execute || die error in execution\n;
while ( my
Scott,
No, and I really don't consider it OT as Platinuum made some pretty good SQL
tuning tools like Plan Analyzer and SQL*Workbench. Regrettably CA's buy out has
pushed those tools out of bounds to many of us. :-(
Dick Goulet
Reply Separator
Well, I wanted to go, but since the terrorist attacks, my company curtailed
all our travel. They specifically mentioned that attendance at conferences
was unnecessary and we couldn't go. Maybe Rachel could carry a video
camera and record it for all the rest of us. I really hate to miss the Larry
Chris,
Basically the error 3113 is bit different from
the other errors. Most of the errors (if not
all ORA errors other than 3113 and 1041 I think)
are generated from rdbms kernel where as 3113 is
generated from the client side,
You won't be able to get an error stack trace
or
Group,
I have a partition that has 1 million records that is joined to 4 other
tables. In order to get an acceptable response time I added two additional
indexes. The response time is now acceptable but the load time is
unacceptable. I truncate the partition prior to the load. Is there any way
not gonna do it.. you've never seen videos I've taken. they usually
videotape and broadcast the general sessions (and definitely Larry) on
the oracle website
--- Carle, William T (Bill), NLCIO [EMAIL PROTECTED] wrote:
Well, I wanted to go, but since the terrorist attacks, my company
curtailed
Bill,
Actually, if I remember correctly, they will make a video of Larry's speech
available from the web for free. So I would poke around the Oracle/OOW
website during/after OOW.
But IOUG is the way to go.
-Original Message-
Sent: Monday, October 01, 2001 4:03 PM
To: Multiple
Gopal,
I have tried it many times (dumping errorstack at level 3 on 3113) but
somehow it didn't give the analyst any clue. I don't know why ... and
neither did he (the analyst). Of course none of my errors are related to
JVM, we haven't started putting JAVA in our DB, that's for 9i
List,
I have two schema. The tables in both schema are having same name and
structures.
Is there any tool to compare the data between two schema tabels?
Thanks,
Rao
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rao, Maheswara
INET: [EMAIL PROTECTED]
Fat City
Hello !
I need to know what is the meaning of the save undo block and save
undo header statistics in the V$WAITSTAT view.
TIA.
Alejandra.
_
Descargue GRATUITAMENTE MSN Explorer en
yeah, the only reason I am doing both is 'cause I made it part of my
contract that they send me to two
--- Adams, Matthew (GEA, 088130) [EMAIL PROTECTED] wrote:
I'd be going if I could get work to pay for it.
heck, I'd go if I could get free hotel (and pay the
rest myself).
That being
I'd watch it on the website but I don't have enough vacation time left to
make it through one of Larry's speeches.
--Walt Weaver
Bozeman, Montana
-Original Message-
Sent: Monday, October 01, 2001 2:22 PM
To: Multiple recipients of list ORACLE-L
not gonna do it.. you've never seen
not gonna do it.. you've never seen videos I've taken.
oh - but I've seen you in videos! :0
not gonna do it.. you've never seen videos I've taken. they usually
videotape and broadcast the general sessions (and definitely Larry) on
the oracle website
--- Carle, William T (Bill), NLCIO
Hi!
sorry ..this may not be 'directly' related to your problem..
But, I am curious to know how you are 'managing'
8.1.7.1 with its bug of '566 session limit'.
Cyril
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cyril Thankappan
INET: [EMAIL
I can set a procedure to a block in Forms 6i . But
can not do it to a procedure in a package . IS IT POSSIBLE?
Thanks .
bunyamin
rollback=undo
-Original Message-
Sent: Monday, October 01, 2001 4:30 PM
To: Multiple recipients of list ORACLE-L
Hello !
I need to know what is the meaning of the save undo block and save
undo header statistics in the V$WAITSTAT view.
TIA.
Alejandra.
--
Thank you Michael! set
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P9 in profile does
solve a part of my problem!
Now if I insert â from sqlplus on NT side and do a
select from sqlplus on Unix, I got â! Thank godness.
The only strange thing I have now is I cannot do
insert correctly from Unix. In
Under the Column count , Is a SMALL Value of Execute ( = 2) Versus a
Large Value of Fetch ( = 2525 ) considered Good or Expensive for
performance ?
NOTE -
TBA_FLEXI_FIXED_PARM_TBL Contains 600,000 records only
2 indexes exist on TBA_FLEXI_FIXED_PARM_TBL
Index 1 = UNIQUE index on acid
Index 2
Hi,
I've read in Tom Kyte's book the following technique:
For i in (Select statement ) Loop
Process records here
End Loop ;
I have tried it and it works great.
The question is that what is the difference betwen a cursor and the code above?
Which is more efficient?
Thank
If you are looking for Third Party tools then I would suggest Schema
Manager from Quest.
Rao, Maheswara wrote:
List,
I have two schema. The tables in both schema are having same name and
structures.
Is there any tool to compare the data between two schema tabels?
Thanks,
Rao
--
There is SKIP_UNUSABLE_INDEXES option in SQLldr
--- Rusnak, George A. [EMAIL PROTECTED]
wrote:
Group,
I have a partition that has 1 million records that
is joined to 4 other
tables. In order to get an acceptable response time
I added two additional
indexes. The response time is now
Hello,
I'll do an reorganization of a database (about 140 gigs). Some people say
that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be
160K, 4M and 160M. Which size do you advice me ? I have also many small
indexes (less than 16K).
Regards,
Thanh-truc Nguyen
--
Please
What is in V$LATCH. If its shared pool and library
cache contention I'd be tempted to:
a) upgrade to 8.1.6+ where the algorithm is better
b) reduce the size of your shared pool
hth
connor
--- Gupta, Brijesh [EMAIL PROTECTED]
wrote: Hi all
My database almost hangs and when I query the
the code IS a cursor
--- Csillag Zsolt [EMAIL PROTECTED] wrote:
Hi,
I've read in Tom Kyte's book the following technique:
For i in (Select statement ) Loop
Process records here
End Loop ;
I have tried it and it works great.
The question is that what is
Could anyone tell me why following nested loop does work? It stopped after
inner loop finished. I tried for loop, it worked ok.
Thanks,
Jun
declare v_plan_id number;
v_channel_id pricing_plan.channel_id%TYPE;
v_row pricing_plan%ROWTYPE;
cursor plan_id is
select distinct
Tom,
H!!! I thought I paid you enough to forget about those! :)
Dang!
Rachel
--- Mercadante, Thomas F [EMAIL PROTECTED] wrote:
not gonna do it.. you've never seen videos I've taken.
oh - but I've seen you in videos! :0
not gonna do it.. you've never seen videos I've
Hi DBA's
Today, our production users started to get the following error at their
Win NT Oracle 8.0.5. client workstations.
ORA-12500 TNS Listener failed to start a dedicated server process
I was not running Spotlight at the time and I could not connect to the
instance using Server Manager. I
Hi, all
Is there a way to clone/copy a cursor? I have a
cursor, after looping throught it, I would like to go
to the beginning and loop again. If I open the cursor
again, my impression is that the cursor does a new
select, which might not return the exact same rows as
before, since the data
The 'For I in...' is an implicit cursor
To define/declare a cursor is explicit.
I've used both. The 'For i in...' is down, dirty and very fast.
-Original Message-
Sent: Monday, October 01, 2001 3:50 PM
To: Multiple recipients of list ORACLE-L
the code IS a cursor
--- Csillag Zsolt
Hi,
If this code is a cursor then why doesn't everybody use it this way?
For me it seems a lot simplier and easier than declaring a cursor in a
normal way.
At 14:50 2001.10.01. -0800, you wrote:
the code IS a cursor
--- Csillag Zsolt [EMAIL PROTECTED] wrote:
Hi,
I've read in Tom
How to Stop Defragmenting and Start Living can be found at:
http://technet.oracle.com/deploy/availability/pdf/defrag.pdf
-Original Message-
Sent: Monday, October 01, 2001 5:35 PM
To: Multiple recipients of list ORACLE-L
Hello,
I'll do an reorganization of a database (about 140 gigs).
Thanh - I believe the 128k / 4m / 128m comes from the paper Stop
defragmenting and start living (I hope I am recalling the name of the
article correctly), which is posted on Oracle's Web site. It references the
fact that it bases those sizes on Oracle8i, and mentions that Oracle is
recommending
May be it is good practice to keep number of extents to be less than 50, no
matter what the size of extent.
-Original Message-
Sent: Monday, October 01, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L
Hello,
I'll do an reorganization of a database (about 140 gigs). Some people
I think you have more 'control' over the explicit cursor. I've seen some
nifty little
tricks with explicit cursors.
-Original Message-
Sent: Monday, October 01, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L
Hi,
If this code is a cursor then why doesn't everybody use it this
Hi Denmark,
Unfortunately no answers just a few more questions.
What is the listener logfile - any error messages?
Also, are there any messages in the alert log or user dump directory?
Regards,
Bruce Reardon
-Original Message-
Sent: Tuesday, 2 October 2001 9:10
Hi DBA's
Today, our
Hi DBA's
Our production database has a tablespace with the following schema:
CREATE TABLESPACE IRD_DATA_LARGE
DATAFILE 'E:\ORANT\DATABASE\USR1PROD.ORA' SIZE 128472K AUTOEXTEND ON
NEXT 2K MAXSIZE UNLIMITED
LOGGING
DEFAULT STORAGE(INITIAL 100K
NEXT 100K
If you only use a cursor in this manner, the only place that the cursor can
be used is in the particular For Loop in which it is defined - it can't be
shared by other procedures or functions.
If you design and create packaged public cursors, they can be reused from
other stored procedures and/or
Hi everyone --
Well, it's been an challenging month for all of us, hasn't it? ;-) I
promised to give you all a summary, and my apologies for taking so long to
get back to you on this. The postal donations took a while to get to me,
and I'm actually still getting PayPal donations even today, so
Please delete
Make a difference, help support the relief efforts in the U.S.
http://clubs.lycos.com/live/events/september11.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viraj Luthra
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
Why?
Wong, Bing
bing.wong@Ingram To:
as others have said, you can't reuse this cursor, or use it anywhere
else.
--- Csillag Zsolt [EMAIL PROTECTED] wrote:
Hi,
If this code is a cursor then why doesn't everybody use it this way?
For me it seems a lot simplier and easier than declaring a cursor in
a
normal way.
At
I never cared for Oracle Open World, it was just one
big commercial. The only cool thing about it, is
seeing all my friends who started their own Oracle
consulting firms or working for someone that I know.
Plus I'm a shop-a-holic and I spend way too much money
on Oracle clothes and junk, like
ok, I know the meaning of the undo block and undo header statistics, but
I don't know how to understand the save undo block and save undo header
statistics.
From: Mohan, Ross [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject:
I think that the Change Management Pack of the Oracle Enterprise Manager may
be useful to you.
From: Rao, Maheswara [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Comparing data between two tables in two schema
Date: Mon, 01
You can also use the for loop - end loop with explicit cursors.. You don't
have to define the cursor in the loop itself.. That is my preferred method
(defining the cursor in the declare section and referencing it in the for
loop).. There really isn't any more work defining the cursor up front
A Small Addition :-
SST Table only has 50 Records with index on (set_id,sol_id)
Qs. Under the Column count , Is a SMALL Value of Execute ( = 2)
Versus a
Large Value of Fetch ( = 2525 ) considered Good or Expensive for
performance ?
Qs. What does the above mean to indicate ?
I am Quite basic in
Hi all
Does anyone know how to unlock a locked table?
Thanks in advance
Ha Duy Thien
__
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Hi lists,
I have a tablespace that is 600 M size, has 4 million rows.
It is taking nearly 2 hrs to finish the import.
In the meantime, I tried selecting howmany rows imported(from another
session), but every time I issue query,the result is zero.
But after finishing the import I got the
Hi,
Look into imp -feedback.
From the manual (816 Utilities, chapter 2):
FEEDBACK
Default: 0 (zero)
Specifies that Import should display a progress meter in the form of a dot
for n number of rows imported. For example, if you specify FEEDBACK=10,
Import displays a dot each time 10 rows have
Hi Lists,
Shall I close the unix session after submitting my job (compressing the
dmp file after importing) in the background on solaris.
$ compress /u01/dmps/zvr_dd.dmp
is this harmful ? (like killing the running jobs)
thnx in adv
srinivas
--
Please see the official ORACLE-L FAQ:
Srinivas,
Do you have any indexes, constraints, triggers on this table
When trying to import.
Cause this can reduce import performance substantially.
Just to let you know, on a DELL 6450 Windoze NT Server, I get can import 2
million records per minute as long as there are no indexes or
1 - 100 of 102 matches
Mail list logo