ORA 02068 error occurs when the program is executed, how to solve it? 10

The question is complicated, you have it: ORA-8103

There are detailed solutions.

The database is divided into 3 tablespaces: big, medium, and normal When importing the table structure from the production environment into the development environment, I get the error imp-00003: oracle error 1659 encountered.

The main problem is that when we need to import the tables in the big tablespace to other environments, the value of the initialization allocation tablespace is too large. Solution:

1。When exporting the table structure, add compress=n to the end of the exp command

2。This error is still reported during import. Generate the sql file with imp file=indexfile= and then open the sql file using the notepad open tool.

Set the value of the initialization parameter to the minimum and remove the rem comment. Finally, run the statement. Finally, the table structure is successfully established.

The one that confirms yours first? Do I need to pass parameters? If yes, then it should be written like this:

select * from imageinfo where st_zhuangtai=2 and flag is null and depno = (select from do_org_dept d where :1)

Generally, this error is caused by the order not ending, you check it.

First look at (select from do org dept d where

If the return is 1 row, then there is no problem with your SQL.

depno = (select from do_org_dept d where ?)

Is your question mark a parameter binding in your program? Does this sentence only return 1 line?

This should be an old project, but now the writing of the configuration file has been changed, and you must add "-loader", so it is an error.

The easiest way to solve this problem is to uninstall the current webpack and install the version.

**If it is caused by an input error, the operation method is as follows:

1. After opening Oracle in the computer first, as shown in the figure below, check the duplicate data in the table.

2. Then use the distinct removal function to query out the duplicate data, as shown in the following figure.

3. Then create a new table and insert the deduplicated data into the new table, as shown in the figure below.

4. Then use truncate to clear the data in the original table, as shown in the following figure.

5. Finally, insert the duplicate data in the new table into the original table to achieve the effect of deduplicating the data.

I also had this problem when I was doing merge operations before, because a unique key value is needed to decide whether the merge into operation is insert into or update, and the key value in my merge temporary table is not unique, so this error is reported, and the solution is to first hug all the data in the temporary table according to certain rules and the key value is unique.

For example: select a* from merge_test_tmp a where = (select max(merge_test_ from merge_test_tmp where merge_test_ order by desc;

Is it the fault of Insert Into Times? It is estimated that you insert the data into the table, the primary key is not unique, you first put the data you want to insert under the distinct primary key, and remove the duplicate rows.

Just report the error is that the seed datafile in the installation package you cleverly called for is corrupted, and it wants to restore these data files when building the library Xiaotankai but finds a problem, so it will report the error.

askmaclean oracle