It's always a good idea to archive/delete unused/duplicate data. An easy way of freeing up some space.

http://dba.stackexchange.com/questions/12725/add-article-to-transactional-publication-without-generating-new-snapshot

Check the definition of your view - ORA-01858 occurs when you convert a string or a number to date and you have passed some incorrect values

http://www.orafaq.com/wiki/ORA-01858

Don't think this is an...

Did you recently switch from full to simple?

If you had no long-running active transactions that does not make sense.

Great explanation on tran logs here (http://www.sqlshack.com/beginners-guide-sql-server-transaction-logs/[/url])

Best to check the basics first.

1. Network Connectivity to remote server (ping x.x.x.x)

2. Firewall rules denying you access

3. DB Engine on?

Use an UPDATE statement rather than insert?

No problem!

http://blog.sqlauthority.com/2013/05/27/sql-server-how-to-insert-data-from-stored-procedure-to-table-2-different-methods/

then just modify the data.

Perform a count on subscriber and publisher and compare?