Sql Plus how to copy a table with timestamp
<p>I am trying to copy a data from a remote database in SqlPlus.
I have a source table like so</p>

<pre><code>table_name: source_table

seqId  |   createDate 

1   | 10-SEP-02 02.10.10.123000 AM

2   | 10-SEP-01 02.10.10.123000 AM
</code></pre>

<p>with the seqId being a number and createDate being a timestamp.</p>

<p>I attempted to copy the data to my table with:</p>

<pre><code>COPY FROM &amp;user_name/&amp;password@&amp;database
REPLACE x_source_table USING
SELECT * 
FROM source_table;
</code></pre>

<p>but it throws an invalid data error.</p>

<p>I then attempted to cast the createDate in the syntax with</p>

<pre><code>COPY FROM &amp;user_name/&amp;password@&amp;database
REPLACE x_source_table USING
SELECT cast(createDate as Date) as createDate
FROM source_table;
</code></pre>

<p>to attempt to only copy the createDate but it did not work either.</p>