Babu - I don't know how large your tables are, but you should consider
committing during the copy. This is a parameter available to COPY.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, February 06, 2003 8:34 AM
To: Multiple recipient
Hi allThank you very much for all your
suggestions.I already experimented with copy command. But I failed Following
is the output..SQL> copy from qest/qest@ndlp to
scott/tiger@test1 -> append contacts_new using select * from
contacts;Array fetch/bind size is 15. (arraysize is 15)Will commit
05/2003 06:52 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Problem with LONG column
Babu - There are two ways I can think of to do this.
1. Write a small PL/SQL procedure.
2. Use the S
Create the new table, and then use the sqlplus 'copy' command,
as it can handle longs.
Jared
On Wednesday 05 February 2003 02:23, BanarasiBabu Tippa wrote:
> Hi everyone
>
> One of my development team is working on ORACLE 8 on NT (Because of client
> requirement they are working on that version)
Babu - There are two ways I can think of to do this.
1. Write a small PL/SQL procedure.
2. Use the SQL*Plus COPY command.
You will probably use the method that is more familiar to you. Have you used
either PL/SQL or SQL*Plus COPY before?
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL
Look into the SQL*Plus COPY command.
> BanarasiBabu Tippa wrote:
>
> Hi everyone
>
> One of my development team is working on ORACLE 8 on NT (Because of
> client requirement they are working on that version). One Table was
> created with wrong column name. Now they wanted me to correct the
> co
Title: Which rollback segment is currently active?
Hi Banarasi
>One of my development team is working on ORACLE 8 on NT (Because of
client requirement they are working on that version). One Table was created with
wrong column name. Now they wanted me to correct the column name. But
real pr
Title: Which rollback segment is currently active?
Hi
everyone
One of
my development team is working on ORACLE 8 on NT (Because of client requirement
they are working on that version). One Table was created with wrong column name.
Now they wanted me to correct the column name. But real pro