Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Replicating Schemas

3015176Aug 18 2015 — edited Aug 18 2015

I am doing a project in which I need to replicate databases in order to produce some analytics. I have received copies of the DDL files and data insert scripts so that I can replicate the schemas, insert that data and then use Jdeveloper to create what i need. I am having a lot of trouble trying to import the DDL files to replicate the schema. Can you please let me know if there is a good tutorial or how-to document for something like this. Thanks.

Comments

Sasha Gomanuke
Answer

Think about making grants on certain objects (tables etc) of You additional schemes to Your working scheme being parsed.

Marked as Answer by carkxg · Feb 2 2021
carkxg

Thanks very much, Sasha. It was so simple to fix. I just granted SELECT, INSERT, UPDATE, DELETE privileges on one of the GIS tables to the APEXAPPS user (the parsing schema) and now I can see GIS in the dropdown for the Table Owner along with all the GIS tables.
I've been using APEX for a while now but still don't really understand how the workspace is set up - parsing schemas, database schemas, APEX_190200, APEX_PUBLIC_USER, etc.
Anyway, thanks very much for your help.

Sasha Gomanuke

Glad to help. You should look in Oracle features https://oracle-base.com/articles/misc/proxy-users-and-connect-through
or thnk about it as miracle ))

Sylvain Martel

Hello Carkxg,
I would highly recommend that you download the Oracle APEX free intro course from Oracle. You would be able to learn the basic concepts of APEX and execute labs to improve your understanding APEX development, and it's totally free! There is no catch...
Oracle Application Express - Curriculum
Have fun!

carkxg

Thanks. That sounds like a good idea.

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 15 2015
Added on Aug 18 2015
#sql-developer
1 comment
137 views