newbie

[itwizzkid]

I get this error while trying to import a table. Any help welcome.


Export file created by EXPORT:V08.01.06 via conventional path
import done in US7ASCII character set and US7ASCII NCHAR character set
IMP-00003: ORACLE error 1756 encountered
ORA-01756: quoted string not properly terminated
IMP-00000: Import terminated unsuccessfully

Thanks in advance

[tanaw]

that is probably some kind of syntax violation of export format.. look inside export file and check if looks like it should. perhaps you've got corrupt export file..

[UNIX DBA]

Are you importing into the same version of oracle as the export?

[Raminder]

Excerpt from Oracle Documentation:

IMP-00003 ORACLE error number encountered

Cause: Import encountered the referenced Oracle error.

Action: Look up the Oracle message in the ORA message chapters of this manual, and take appropriate action.

ORA-01756 quoted string not properly terminated

Cause: A quoted string must be terminated with a single quote mark (').

Action: Insert the closing quote and retry the statement.

Combinig the above two, my conclusion is:
Since I don't think you would have used any quoted string in your Export/Import control file/ parameter file, it seems to be a version mismatch as suggested by UNIX DBA.

[oratune]

There may be several reasons for this error. Since you do not provide information on the Oracle version you are importing into I must make some 'educated' guesses to provide a response. I shall presume the import is not on the same machine that created the export. If that is the case was the .dmp file transferred to the destination machine via FTP? If so, it is highly likely that the transfer was completed in ASCII mode. This is not the proper transfer type for export files; the transfer must be made in BINARY mode. Try re-transferring the file in BINARY mode and execute the import again.

Should this not solve the problem the next question that arises is this: are the two versions of Oracle the same? You can import a lower version export into a higher version of Oracle (8.0 into 8.1.x, 8.1.x into 9.0, 7.3.x into 8.0 or higher) but you cannot import from a newer release of Oracle into an older version (8.0 into 7.3.x, etc.). I would suspect that if the file transfer was done correctly you're trying to import the 8.1.6 export into an 8.0 or lower database. Oracle IS backward compatible, but it is NOT forward compatible. You CAN use the 8.0 import/export utilities on an 8.1.6 database, and that would allow you to import into an 8.0 database. You should be able to accomplish this remotely; try exporting the data using the 8.0 machine connected to the 8.1.6 instance:

exp80 scott/tiger@ora816 ..... [NT/2000 server]

or

exp scott/tiger@ora816 ..... [UNIX/Linux server]

You should then be able to perform the import without error:

imp80 scott/tiger@ora80 .... [NT/2000]

or

imp scott/tiger@ora80 ... [UNIX/Linux]

One of these two solutions should correct the problem you are experiencing.

[itwizzkid]

Thanks for the response. I followed oratune's advice and ftp'd the exports over in binary mode . It's worked


[Edited by itwizzkid on 11-05-2001 at 10:44 AM]