How to add feature class using ArcCatalog 10.3.1 to another schema. ArcCatalog connected to oracle database as user1. I must to add the feature class to schema on user2. User2 not contain connect privilege. I will be very glad to you suggestions.
To create data under a schema, you have to connect as that User and the user also needs the required permissions for creating data.
Privileges for geodatabases in Oracle—Help | ArcGIS Desktop
Data creatorCREATE SEQUENCECREATE SESSIONCREATE TABLECREATE TRIGGERCREATE VIEW
User2 must have permissions to not only connect, but to also create data.
Apply permissions to User2, then make a database connection as user2 in ArcCatalog. Copy and paste the data into User2's connection. The end results will be duplicated data in the schemas user1 and user2. From there you can delete the data in user1 schema.
Retrieving data ...