Sybase Data Migration Dat file import msg 8009

Source: Internet
Author: User

Tags: io SP file data on 2014 problem BS AD

These two days have been tangled in the Sybase database DAT file import problem, looked up a bunch of data, slowly summed up their own little experience.

Personally think DAT file import must meet the requirement is that the new database space size must be larger than the size of the original database, I now import a 6G dat file, its original database size of 85G, The initial size of the Sybase database should be up to 32G and can be set by ALTER DATABASE DatabaseName on DeviceName (Create a new device name) =size (size, default unit is MB, can use g), My statement is ALTER DATABASE CREDITDB on creditdata02= "30G". If the size of the space can not be satisfied, then the import operation will be error msg 3105,data on dump would not fit into the current database. Need Xxxxmbyte database, which indicates how much space is required to import.

Again msg 8009, my solution is when the load database databasename from "/xxxx/xxxx.dat", Because the original file may be in the dump export generated when the Compress compression command was compressed export generated DAT file, if you want to successfully import, you must add "compress::", my statement is the load database Creditdb from " Compression:sybase/credit_2014.dat ". Unzip the import.

If you want to compress the export DAT file statement is similar,

Dump database Creditdb to "compress::D/creditdb.dat".

Other people encountered with MSG 8009 may have other causes and workarounds. I am only experiencing this situation for the time being.

Sybase Data Migration Dat file import msg 8009

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

Tags Index: