Oracle 12C and Bitbucket

Christopher · August 29, 2017 1:41AM

Hello,
Does anyone know if it is supprting the Oracle 12C and Bibucket? Please let me know, it is urgent, thanks.

Eddie D · August 30, 2017 12:27PM

Hi Christopher,
Source Control for Oracle V4 supports Oracle 12c and Git repositories:

https://documentation.red-gate.com/display/SOCO4/Requirements+and+supported+Oracle+versions

https://documentation.red-gate.com/display/SOCO4/Supported+source+control+systems

Many Thanks
Eddie

nikjohn1538 · January 8, 2019 6:16AM

6

2

I have installed an Oracle 12c database on my system. I had an application which need to access the database.

Previously in Oracle 11g, I used the following commands to create an user.

create user name identified by name;  
grant connect,create session,resource,create view to name;

Can anyone tell me how to create a user in Oracle SOA 12c with my above requirements? I used the following statements but my installation is showing a fatal error saying

FATAL ERROR - java.sql.SQLException: ORA-01950: no privileges on tablespace 'USERS'

Following were the statements used.

create user c##test1 identified by test1 container = ALL;
grant connect,create session,resource,create view to test1

Eddie D · January 8, 2019 10:28AM

Hi nikjohn1538,

I found when creating users in Oracle 12c that you need to specify the user's default tablespace using the commands below when creating the new user:

DEFAULT TABLESPACE USERS QUOTA UNLIMITED|SIZE ON USERS;

Using your example, setting the default tablespace with quota unlimited:

create user c##test1 identified by test1 container = default tablespace USERS quota unlimited on USERS;

Or setting a quota size:

create user c##test1 identified by test1 container = default tablespace USERS quota 20M on USERS;

Oracle 12C and Bitbucket

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk