You should specify column names as below. It’s good practice and probably solve your problem
insert into abc.employees (col1,col2) select col1,col2 from employees where employee_id=100;
EDIT:
As you said employees
has 112 columns (sic!) try to run below select to compare both tables’ columns
select * from ALL_TAB_COLUMNS ATC1 left join ALL_TAB_COLUMNS ATC2 on ATC1.COLUMN_NAME = ATC1.COLUMN_NAME and ATC1.owner = UPPER('2nd owner') where ATC1.owner = UPPER('abc') and ATC2.COLUMN_NAME is null AND ATC1.TABLE_NAME = 'employees'
and than you should upgrade your tables to have the same structure.
Related Posts:
- SQL error “ORA-01722: invalid number”
- QL Error: ORA-00933: SQL command not properly ended
- SQL Error: ORA-00942 table or view does not exist
- SQL not a single-group group function
- SQL error “ORA-01722: invalid number”
- SQL Error: ORA-01861: literal does not match format string 01861
- SQL Queries “00904. 00000 – “%s: invalid identifier”
- ‘NOT LIKE’ in an SQL query
- ORA-00904: invalid identifier
- how to fix oracle ORA-01722 invalid number error
- ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
- ORA-00979 not a group by expression
- ORA-00907: missing right parenthesis
- ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client
- How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
- ORA-28040: No matching authentication protocol exception
- ORA-01843 not a valid month- Comparing Dates
- ORA-00918: column ambiguously defined in SELECT *
- ORA-00984: column not allowed here [duplicate]
- ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
- How to resolve ORA 00936 Missing Expression Error?
- Oracle error : ORA-00905: Missing keyword
- What does SQL Select symbol || mean?
- How do I limit the number of rows returned by an Oracle query after ordering?
- PLS-00201 – identifier must be declared
- Oracle SELECT TOP 10 records
- issue ORA-00001: unique constraint violated coming in INSERT/UPDATE
- Can a foreign key be NULL and/or duplicate?
- How to Select Top 100 rows in Oracle?
- ORA-30926: unable to get a stable set of rows in the source tables
- ORA-12560: TNS:protocol adaptor error
- PLS-00103: Encountered the symbol “CREATE”
- Oracle client ORA-12541: TNS:no listener
- ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
- What does the following Oracle error mean: invalid column index
- ORA-00972 identifier is too long alias column name
- No more data to read from socket error
- What does the following Oracle error mean: invalid column index
- Oracle Apex column link from LOV values
- PLS-00103: Encountered the symbol when expecting one of the following:
- What’s the difference between RANK() and DENSE_RANK() functions in oracle?
- ORA-12899: value too large for column
- Oracle startup not possible – ORA-00845: MEMORY_TARGET not supported on this system – but memory size seems to be fine
- ORA-00918: column ambiguously defined in SELECT *
- ORA-00918: column ambiguously defined in SELECT *
- Oracle date format picture ends before converting entire input string
- Oracle – ORA-01489: result of string concatenation is too long [duplicate]
- SQLPLUS error:ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
- UTL_FILE.FOPEN() procedure not accepting path for directory?
- ORA-01861: literal does not match format string
- ORA-01653: unable to extend table by in tablespace ORA-06512
- Is there a combination of “LIKE” and “IN” in SQL?
- What is it exactly a BLOB in a DBMS context
- “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
- ORA-28001: The password has expired
- ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying
- Oracle “SQL Error: Missing IN or OUT parameter at index:: 1”
- How do you create a temporary table in an Oracle database?
- Oracle “Partition By” Keyword
- How to insert date values into table
- Oracle SQL: Update a table with data from another table
- Oracle SQL query for Date format
- sqldeveloper error : no ocijdbc11 in java.library.path on windows 7
- ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
- Oracle SQL Developer: Failure – Test failed: The Network Adapter could not establish the connection?
- ORA-01747: invalid user.table.column, table.column, or column specification
- SQL selecting rows by most recent date with two unique columns
- ORA-06502: PL/SQL: numeric or value error: character string buffer too small
- Comparing Dates in Oracle SQL
- Convert timestamp to date in Oracle SQL
- How do I reset a sequence in Oracle?
- How to display databases in Oracle 11g using SQL*Plus
- grant select on view
- Update statement with inner join on Oracle
- MySQL equivalent of DECODE function in Oracle
- Hibernate dialect for Oracle Database 11g?
- Query to display all tablespaces in a database and datafiles
- ORA-20002: YOU ARE NOT ALLOWED TO CHANGE THE PASSWORD FOR CRITICAL SCHEMAS
- Oracle: If Table Exists
- DATEDIFF function in Oracle
- How to create id with AUTO_INCREMENT on Oracle?
- LEFT function in Oracle
- What is the difference between Views and Materialized Views in Oracle?
- How can I set a custom date time format in Oracle SQL Developer?
- How to copy files into a virtual box oracle box
- How do I view the Explain Plan in Oracle Sql developer?
- ORA-01779: cannot modify a column which maps to a non key-preserved table
- ORA-01735: invalid ALTER TABLE option – Toad
- Find out the history of SQL queries
- ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
- PLS-00049 bad bind variable While using :OLD
- How to delete from multiple tables in MySQL?
- SQL to check how many sites a user is a member of
- List of posts by day of the week
- What SQL / WordPress queries would need a nonce?
- WordPress SQL Issue not returning correct reselts
- $wpdb query outputs php code instead of executing it
- optimise SQL wordpress call
- Alter SQL query to return posts with unique custom field value, no duplicate values
- How to get from sql query page id and retrieve it url and title