05-16-2017 07:56 AM - edited 05-16-2017 01:24 PM
You can use SAS Enterprise Guide to create/update tables in Oracle, usually using PROC SQL (or the Query Builder) to output to a SAS library defined with SAS/ACCESS to Oracle.
As with all database operations, you need to take care that you're not rewriting tables that you shouldn't. SAS DI Studio supports the discipline of data management whereas SAS Enterprise Guide is more of a general-use application. But if your goal is to add new tables to Oracle, that's simple.
If you have more specific questions about how to accomplish this, I suggest posting back in a new thread with your objective and as much sample data/code as you can muster.