Home » RDBMS Server » Server Utilities » Loading data into tables (Oracle 9i, 9.0.1.0, Solaris 8)
Loading data into tables [message #481010] Fri, 29 October 2010 02:51 Go to next message
reym21
Messages: 178
Registered: February 2010
Location: Philippines
Senior Member

Guys,

We completed creating a replicate of dB_01 to dB_02 (housed in a single DEV server). But dB_02 had only table structures (no records). What would be our fastest option (tools, commands, etc.) to load more than a thousand new records for each of the 20 tables of dB_02?

Thanks for your help.

Re: Loading data into tables [message #481012 is a reply to message #481010] Fri, 29 October 2010 02:57 Go to previous messageGo to next message
Michel Cadot
Messages: 59293
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
What would be our fastest option (tools, commands, etc.) to load more than a thousand new records

Not clear, load from existing rows or load completly new rows?
Is there any dependency (FK) between the tables?

Regards
Michel

[Updated on: Fri, 29 October 2010 02:58]

Report message to a moderator

Re: Loading data into tables [message #481017 is a reply to message #481012] Fri, 29 October 2010 03:41 Go to previous messageGo to next message
reym21
Messages: 178
Registered: February 2010
Location: Philippines
Senior Member

Yes. Completely new rows with no dependencies (FK) at all.

Thanks.
Re: Loading data into tables [message #481042 is a reply to message #481017] Fri, 29 October 2010 09:48 Go to previous messageGo to next message
Michel Cadot
Messages: 59293
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
New rows with which (kind of) data?

Regards
Michel
Re: Loading data into tables [message #481219 is a reply to message #481042] Mon, 01 November 2010 21:42 Go to previous messageGo to next message
reym21
Messages: 178
Registered: February 2010
Location: Philippines
Senior Member

Sorry for this late reply...

Actually, it's a new sets of data (rows) of which to be used for the same application of dB_01... dB_02 would be used for testing the enhancements to be made with the applications of dB_01 currently used in production.

Many thanks.
Re: Loading data into tables [message #481237 is a reply to message #481219] Tue, 02 November 2010 02:09 Go to previous messageGo to next message
Michel Cadot
Messages: 59293
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The question remains.
Do you want random data?

Regards
Michel
Re: Loading data into tables [message #481381 is a reply to message #481237] Tue, 02 November 2010 19:47 Go to previous messageGo to next message
reym21
Messages: 178
Registered: February 2010
Location: Philippines
Senior Member

Yes.
Re: Loading data into tables [message #481382 is a reply to message #481381] Tue, 02 November 2010 20:28 Go to previous message
Barbara Boehmer
Messages: 7991
Registered: November 2002
Location: California, USA
Senior Member
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2151576678914
Previous Topic: SQL Function Greatest
Next Topic: Importing from 9i to 11g with compressed extents creating extents on target
Goto Forum:
  


Current Time: Thu Oct 02 04:39:02 CDT 2014

Total time taken to generate the page: 0.08292 seconds