New answers tagged

0

You have created a CDB (Container Database), and connected to the root container. There you are not allowed to create regular users, you can create common users whose name starts with C##. If you do not care about or want to use pluggable databases, I suggest that you drop your empty 12c database, and create a new non-CDB with DBCA (Database Configuration ...


0

These locks can be selected from V$LOCK (or GV$LOCK for RAC) SELECT * FROM gv$lock WHERE lock_type = 'UL' AND '1073741825' like id1||'%' 1073741825 - is lockid column from dbms_lock_allocated table or you may get it by dbms_lock.allocate_unique('YOUR_LOCK_NAME',:lock_id);


2

Sure, just create a job. For example, update column every midnight: begin dbms_scheduler.create_job ( job_name => 'UPDATE_TABLE', job_type => 'PLSQL_BLOCK', job_action => 'begin update table set column = value; commit; end;', start_date => trunc(sysdate+1), repeat_interval => ...


1

They're vastly different when it comes to other features, such as security, programming languages, data types, tools, end user support, requirements, etc. However, they're both compliant with basic SQL92 (and perhaps other SQL standards), so one can do the same basic schema creation and data querying and manipulation. You should be able to do the basics ...


-2

Set the owner of Oracle services to be the domain admin account.


4

You have just ended the single quote near 'cus_id in(select cus_id from employee where comp_id = NVL(SYS_CONTEXT(' so that the compiler is expecting the ; to end the statement but it has found Hello_Context','COMP_ID'),0)');. If you want to use single quote inside another single quote you can use q operator as demonstrated below. For details:Literals ...


2

According to the question all you need to do is attach a predicate on query to customer table as shown below. select * from customer where company_id in(select company_id from user_info where Admin='admin_user'); Right? So you have to create a function which should return a predicate as: company_id in(select company_id from user_info where ...


2

There is no trcroute for the instant client, but even if you had the full administrator client, trcroute may not return anything useful. By the way, from the command line I can ping the destination DB (defined in tnsnames.ora) just fine, so I believe I can completely rule out the networking (e.g. DNS/firewall/accessibility). And that is the mistake ...



Top 50 recent answers are included