Problem in importing database with dbimport -l command.
shyam,
you can use tbtape -s -N database to change the logging of a database.
>
> We use dbimport -l <database name> to import the previously exported data.
> The database is about 1GB size, dbimport -l gives an error "Too long
> transaction " while loading data to a table which has about 200,000 records.
>
> Is there a parameter i need to change? Or I can only use dbimport without -l
> option? If we don't use -l how do we turn the logging for a database after
> creating the database?
>
> If you have any solution please send email to shyam@minerva.robadome.com.
>
> Thank You
>
> Shyam
>
>
>
>
--
regards,
+----------------------------------------------------------------------------+
| . . | |
| ... ... | Bob Baskett |
| ..... ..... | Software Engineer, DBA |
| .. ... .. | Business Systems Integration Group |
| . . . | Semiconductor Products Sector |
| | Mesa, AZ |
| Motorola, Inc. | |
|----------------------------------------------------------------------------|
| 'connectionLESS IS MORE' -- Data Broker |
|----------------------------------------------------------------------------|
| Duct tape is like the force. It has a light side, and a dark side, and |
| it holds the universe together ... |
| -- Carl Zwanzig |
+----------------------------------------------------------------------------+