Since Oracle 9i there are two ways or declaring a directory for use with UTL_FILE. The older way is to set the INIT.ORA parameter UTL_FILE_DIR. We have to restart the database for a change to take affect. The value can like any other PATH variable; it accepts wildcards. Using this approach means passing the directory … Read more
You should specify column names as below. It’s good practice and probably solve your problem EDIT: As you said employees has 112 columns (sic!) try to run below select to compare both tables’ columns and than you should upgrade your tables to have the same structure.
You’re missing service name: EDIT If you can connect to the database from other computer try running there: and
Perhaps you should check NLS_DATE_FORMAT and use the date string conforming the format. Or you can use to_date function within the INSERT statement, like the following: Additionally, Oracle DATE stores date and time information together.
You might be using Automatic Memory Management (AMM). AMM uses two initialization parameters: MEMORY_TARGET MEMORY_MAX_TARGET The shared memory file system should have enough space to accommodate the MEMORY_TARGET and MEMORY_MAX_TARGET values. To verify: In UNIX/Linux, you will have to set the shared memory file system accordingly. Verify: Set: For example,
have a look into this blog, the problem resolved for me by changing the column datatype from varchar(100) to varchar(100 char). in my case the data contains some umlaut characters. http://gerardnico.com/wiki/database/oracle/byte_or_character
For errors like this you should involve oracle support. Unfortunately you do not mention what oracle release you are using. The error can be related to optimizer bind peeking. Depending on the oracle version different workarounds apply. You have two ways to address this: upgrade to 11.2 set oracle parameter _optim_peek_user_binds = false Of course underscore parameters … Read more
I am getting the above error when trying to connect to a server database from a client using service name orcl. It is getting connected when I am using the other service name i.e. dms Below is my listener.ora Please tell me what to do?
An ORA-01722 error occurs when an attempt is made to convert a character string into a number, and the string cannot be converted into a number. Without seeing your table definition, it looks like you’re trying to convert the numeric sequence at the end of your values list to a number, and the spaces that … Read more
You need to set oracle to listen on all ip addresses (by default, it listens only to localhost connections.) Step 1 – Edit listener.ora This file is located in: Windows: %ORACLE_HOME%\network\admin\listener.ora. Linux: $ORACLE_HOME/network/admin/listener.ora Replace localhost with 0.0.0.0 Step 2 – Restart Oracle services Windows: WinKey + rservices.msc Linux (CentOs):sudo systemctl restart oracle-xe