Oracle

Problem: Imp-00019: Row reject due to Oracle error 12899Imp-00003: encountered Oracle error 12899ORA-12899: column "jackeyj". "jk_register". "opname" is too large (actual value: 21, maximum value: 20) Column 1 523 This error occurs when the IMP

Today, we see a project in the company. there is also. the SQL files are the imported data files and table structure files. The data files here are only the data in the table and so on ,. the SQL file is a tablespace and table structure file. First,

In some cases, the stored procedure in Oracle becomes invalid. A Red Cross is displayed in the upper left corner of the stored procedure icon in PL/SQL developer. For example, if the objects referenced in the stored procedure are invalid, dblink may

[Cause/trigger factor] This is because "password_life_time = 180 days" is set in the default profile in oracle11g by default. [Impact and risk] Impact After the password expires, the business process has an exception connecting to the

/* Data packets (related functions, processes, types, Variables are put into a data packet to implement public variables, Use of process functions for custom types )*/ -- Description of data packets Create or replace package mypack As Type

Definition of a Multi-Table view: if the data source of a view has only one data table, the view is a single-Table view. If the data source of a view is multiple data tables, the view is a multi-Table view.Updatable view definition: in most people's

Create or replace procedure procsendemail (p_txt varchar2, p_sub varchar2, p_sendor varchar2, p_receiver varchar2, p_server varchar2, p_port number default 25, p_need_smtp int default 0, p_user varchar2 default null, p_pass varchar2 default null,

* *** SQL *** and ID in (156,296,272, 48,261,239, 46,120,199, 93 );   * *** SQL *** and ID in (156,296,272, 48,261,239, 46,120,199, 93) order by case ID When 156 then 1 When 296 then 2 When 272 then 3 When 48 then 4 When 261 then 5 When 239 then

Keyword: Oracle date function next_dayIn Oracle, next_day is provided to find the next date of the specified date. Syntax: next_day (date, weekday) Date is used to find the next weekday.Weekday is a day of the week (ie: Sunday, Monday, Tuesday,

5.4 The following error is prompted when installing Oracle 10 GB:   Exception in thread "main" Java. lang. unsatisfiedlinkerror:/tmp/OraInstall2009-11-25_02-34-42PM/JRE/1.4.2/lib/i386/libawt. so: libxp. so.6: cannot open shared object file: no

Ocalhost requires the user name and passwordAfter both Tomcat and Oracle9i are installed, start Tomcat -- connect to localhost. The prompt is: the localhost on the XDB server requires the user name and password, because the port is in conflict. The

Reprinted from: http://imxming.blog.163.com/blog/static/129365520201132710434635/ 1. How to view the running stored procedures in Oracle Select owner, name from V $ db_object_cache where type like '% proce %' and locks> 0 and pins> 0; 2. How to stop

Error code: ORA-06508 Appearance:Oracle 10g (release 10.1.0.2.0)PL/SQL developer 6.0Drop the package in PL/SQL developer and re-compile the package. Then, the image of the stored procedure using this package is displayed (or click the screen ).When

In production, you often encounter the need to import a large number of table values to a local text file. there are many methods. Commonly used is the spool command: to output data files that meet the required format, you only need to use character

Chinese characters are garbled during Oracle Installation on Linux At the beginning, it was relatively time-consuming and can only be installed in English. After repeated trials and sorting, the Oracle Chinese garbled characters in Linux can be

Because of the project requirements, we need to transfer the items on Oracle to DB2, So we collected some precautions for modification and shared them with you.  Examples of implementing the same functions of Oracle and DB2 (taking Oracle8i

Oracle Database is the most widely used database in today's field. It is also a huge system. It requires not only some theoretical knowledge, but also development and engineering experience to fully understand it. I am an oracle enthusiast. I hope

Summary Materials are the foundation of the entire ERP, and almost all business operations are transferred around materials. In Oracle EBS, there are nearly 280 material attributes. It is almost impossible to set them one by one. Most of the

F.3 numeric Functions The function accepts parameters of the number type and returns numeric values of the number type. The return values of beyond functions and trigonometric functions are precise to 36 bits. The results of ACOs, asin, atan, and

During Development under jdeveloper these two days, the following problem occurs:Right-click helloworld and choose "run ". You have insufficient privileges for the current operationUsername:Password: (The image was supposed to be uploaded, but it