SQL Language (MOSC)

MOSC Banner

Insert into Statement

edited Aug 25, 2015 10:41AM in SQL Language (MOSC) 8 commentsAnswered ✓

Oracle Installed:

On RAC

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

"CORE 11.2.0.3.0 Production"

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

Linux: Red Hat 64 bit

Question: I am asked to copy/insert record from one table on a server A  to a similar table on a server B.  How do I copy/insert the creation and modified date columns?

Screen shots of my insert CMD and Desc table are below. I will run that insert command after I get recommendations from you.

Thank you for your help.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center