Re: Problem copying tables - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Re: Problem copying tables

Author

Topic

novice82
Starting Member

5 Posts

Posted - 2009-07-16 : 05:52:55

Hello Members,

Its my first day using SQL queries on oracle 10g database.

I used the following query to copy selected feilds of a table :

Creating a table n copying selected fields:

CREATE TABLE SAMPLE_TEMP as (SELECT CUST, BALANCE FROM CUSTOMER_ALL)

The CUSTOMER_ALL table has over 2 million records. I was successful in creating a table and copying data, but the new table could populate only 52978 records.

How do I go about fixing this ? Do i need to declare a structure and assign the number of records i will store to it ? Any guidance will help me get started.

Regards

newbie

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-07-16 : 05:54:28

Better try to get a solution in ORACLE-Forum?

No, you're never too old to Yak'n'Roll if you're too young to die.