Re: How to create a table in a script?

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Wed, 5 May 1999 09:47:56 -0400
Message-ID: <7gpi15$2va$1@autumn.news.rcn.net>

Arno,

    I don't understand why you are having a problem. The example I used is derived directly from a 6803 line script that I used just three weeks ago to create a copy of a database with 264 tables. I was able to create all 264 tables successfully.

    I did have trouble loading the data into one of the tables. It is a single row table with 195 columns. I had no problems loading any of the other tables including several with about 1 million rows and up to one hundred columns.

    Double check your syntax and if it is correct I suspect that the problem is one of size limitations and that the same limitations will apply to PL/SQL as apply to SQL*Plus.

regards

Jerry Gitomer

---

---

Arno van Rossum wrote in message <37302E8D.94A7F5E3_at_mmp-obec.nl>...
>Jerry Gitomer wrote:
>
>> Based on your description what you are doing should work. The following
>> will work.
>That was what i was thinking too :-) But it appeared to turn out
>otherwise.
>
>> Contents of file called: cr_tbls.sql
>>
>> CREATE TABLE test1 (
>> id number(7),
>> description varchar2(30));
>>
>> CREATE TABLE test2 (
>> ssn number(9),
>> first varchar2(20),
>> last varchar2(20));
>>
>
>I agree that this will work (just two short tables), but I have a very
>long file, with lots of tables. After a few tables SQL*plus stops
>creating tables with te error "input to long, truncated ... " or
>something alike.
>
>That's why I was thinking of a pl/sql script (see original post).
>
>Maybe you have a clue?
>
>Regards,
>
>Arno van Rossum
Received on Wed May 05 1999 - 08:47:56 CDT