Tom Kyte

Goldengate is primarily sold as an Replication software, I understand. Can you clarify whether GG can be used to migrate from one database platform to Oracle. Say, MSSQL for example? Or is it required to use SQL Dev to convert the metadata from...

Hi, I created a package Order_headers with two procedures price and quantity in Tan Schema .called them in other procedure like this tan.order_headers.price; but i got Error like PLS-00302: component Component 'order_headers' must be declared. but...

Can we access the procedure in a package outside the package using another package? i.e. i need to access a package procedure outside of another package (i need to call from 2nd package to access the first package procedure)

Hi Tom, I am hoping for some expert advice on the above, We have a T5 server using SAN storage which is allocated by ZFS. We have Solaris 11 OS and Oracle Database 12c with single instances (no RAC) and we do not use ASM, our database is limi...

It takes a certain amount of database access to be able to create a sql tuning set. It is more than a little fuzzy to me what kind of object they are in the database. My question though is a little more focused than that ( maybe ha ha ). How can...

Hi, Good Day ! Today we have a structured approach to access control, based on use of schemas (to group together database objects), and assigning specific permissions to roles. 2 roles : - USER_ROLE = CONNECT + SELECT/INSERT/UPDATE/DELETE...

Below is the the employee table, EID NAME SALARY COMM_PCT 100 Steven 24000 101 Neena 17000 0.6 102 Lex 17000 0.8 145 John 14000 0.4 If I do the below select to employee table I get the output as 3. SELECT DENSE_RANK(17000,0.6) W...

Hello Tom, I know Tom has retired. But glad that a group of Oracle expertise help to keep operation of AskTom. It is indeed very helpful. I was facing a SQL plan issue in an SAP/Oracle Environment. The SQL is: <code> SELECT DISTINCT "M...

Hi, Need suggestion to get an Alert message over the Listener Log file's growth, now each file gets 10M. We want an alert message over 1GB of the combined listener log files. Regards Binoj

I am planning to install Oracle Linux 7.3 on VMware. This server will be used to host our oracle enterprise manager 13c and its repository database. I have no experience as a server administrator. Currently I am in a situation were I have to setu...

Hi, I'm having trouble using Windows authentication with my database accounts. I have a front-end application that creates a user account based on what their OS username is, OPS$Username, disregarding the domain name. Logging into the application ...

We recently upgraded databases from 11.2.0.4 to 12.1.0.2. With that upgrade, we noticed that after submitted jobs via dbms_job, the procedures can take anywhere between 5-30 seconds in order to actually start to execute after committing. A sample scr...

I have a global partition on an INDEX as below (the table was partitioned on different keys) Fiscal year, period_cd, and 2 more keys as shown <code>CREATE INDEX kr.ufy_idx_px ON kr.LD_LDGR_ENTR_T ( u_fy, u_prd_cd, c_cd, obj_cd) GLOBAL PAR...

Hi Can we update data in Materialized view directly using update statement. If yes,will that updated to table as well. What if there are more than one table in view? Please help me on this.

Hi all, I use CTXRULE to classify some text, but AB&B work and AT&T not work. Please support me on this: Here is my search text <code> SQL> select text from test_lexer_special; TEXT -------------------- AB&B {AT&T} AT&T SQL></code> ...

Hello Masters :-), I read the documentation about fast refreshable materialized views. It states: "The changes for conventional DML changes are stored in the materialized view log associated with the master table. The changes for direct-path IN...

Hi Tom I have an input file that contains data that is tab delimited containing info like name, type, date, result, value as separate rows. The fields are not enclosed in quotes or anything else. I need to populate sequence for the data while load...

Hello Experts, I have a requirement wherein I need to unload/export web page contents whose data is populated by javascript to a text/csv file; which in turn will be be loaded in the database table. I am not sure if utl_http will get the job d...

1. Use table [Employee] Write a stored procedure named Get_Employee_Detail which will accept 2 parameters. @col_name varchar(100) @col_value varchar(500) col_name parameter can accept any column name from the table and col_val...

Hi, We are getting enq: FB - contention for some client and its because of Insert statement. We have Very few Oracle document and SR's created to this can we have an idea on why we are getting this and way to find and fix the issue ( possible w...