Re: Another Transferring data from one table to another fast Q

Title: RE: Transferring data from one table to another SQL*Plus COPY command can do it, truncating the contents of the LONG after the length specified by by SET LONG command... - Original Message - From: Shaw John-P55297 To: Multiple recipients of list ORACLE-L

RE: Transferring data from one table to another

Thank you all SQL*Plus COPY command seems most suitable, I will try it out today. Aleem -Original Message- Sent: Monday, August 12, 2002 7:33 PM To: Multiple recipients of list ORACLE-L Subject:Re: Transferring data from one table to another Did you check out the SQL

Another Transferring data from one table to another fast Q

Title: RE: Transferring data from one table to another How about if your table has (I didn't do it) a LONG column. CTAS doesn't work and I don't see the nologging option for the ccopy command - in 8.1.6 anyway. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: Transferring data from one table to another

I think the pl/sql route is the better, but if you had time to tolerate a slower load, you could write a nested SQL*Plus script which would give you all the control you require. I have done this on tables up to the million mark. I assume your space definitions are optimum? peter edinburgh

RE: Another Transferring data from one table to another fast Q

:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 9:18 AM To: Multiple recipients of list ORACLE-L Subject: Another Transferring data from one table to another fast Q How about if your table has (I didn't do it) a LONG column. CTAS doesn't work

RE: Another Transferring data from one table to another fast Q

Title: RE: Another Transferring data from one table to another fast Q Yes, but direct SQL with CTAS is faster. Of course, could put nologging on table after creation but then need separate ddl script. Still like CTAS. -Original Message- From: Baker, Barbara [mailto:[EMAIL PROTECTED

RE: Transferring data from one table to another

of list ORACLE-L Subject:RE: Transferring data from one table to another well if u wanna commit after 1000 records u could very well use a cursor and within the loop keep a counter which will indicate the no. of records inserted...upon reaching 1000 records just commit and reinitialize

RE: Transferring data from one table to another

Message- Sent: Monday, August 12, 2002 10:43 AM To: Multiple recipients of list ORACLE-L Subject:RE: Transferring data from one table to another well if u wanna commit after 1000 records u could very well use a cursor and within the loop keep a counter which will indicate

RE: Transferring data from one table to another

Abdul In terms of committing every so many records, investigate the SQL*Net COPY command if you are not familiar with it. For transferring this many records, you may also want to investigate CREATE TABLE AS SELECT . . . . NOLOGGING Dennis Williams DBA Lifetouch, Inc. [EMAIL

Re: Transferring data from one table to another

data from one table to another well if u wanna commit after 1000 records u could very well use a cursor and within the loop keep a counter which will indicate the no. of records inserted...upon reaching 1000 records just commit and reinitialize the counter.. i have written the Pseudo code below

RE: Transferring data from one table to another

: Transferring data from one table to another Date: Sun, 11 Aug 2002 23:23:19 -0800 Thank you, Amjad, The problem is that then I have to write a procedure for each of the tables. I was looking for something that could be set at database level and would apply to every table. Aleem -Original Message

RE: Transferring data from one table to another

is which one is efficient, CTAS or using cursor in pl/sql Procedure!! thanks peter. From: Abdul Aleem [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Transferring data from one table to another Date: Sun, 11 Aug 2002 23:23:19 -0800

RE: Transferring data from one table to another

Title: RE: Transferring data from one table to another CTAS with nologging. Could create a simple script to do this. -Original Message- From: Peter R [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Subject: RE: Transferring

RE: Transferring data from one table to another

[EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Transferring data from one table to another Date: Sun, 11 Aug 2002 23:23:19 -0800 Thank you, Amjad, The problem is that then I have to write a procedure for each

RE: Transferring data from one table to another

of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Transferring data from one table to another Date: Sun, 11 Aug 2002 23:23:19 -0800 Thank you, Amjad, The problem is that then I have to write a procedure for each of the tables. I was looking for something that could be set at database level

Transferring data from one table to another

Hi, We are transferring data from one table in a schema to another table in another schema with identical fields using INSERT INTO schema1.abc (SELECT * from schema2.abc) The source table has 1.6 million records. The tablespace increases to consume full disk space and yet seems to be demanding

RE: Transferring data from one table to another

well if u wanna commit after 1000 records u could very well use a cursor and within the loop keep a counter which will indicate the no. of records inserted...upon reaching 1000 records just commit and reinitialize the counter.. i have written the Pseudo code below: declare cursor c1 is