New answers tagged

0

Is this doable in GoldenGate(GG)? The Map or Table parameter can be used to select Table, depending on whether to apply in Extract or in Replicat. The Cols and ColsEXCEPT attributes of the Table parameter can be used for Columns selection. I believe that the Oracle's official documentation is good link to create the solution. Here are some. ...


0

The Oracle database instance has several background sessions it creates in order to function, and those count against the number of sessions. For example, here is an Oracle 12c instance, one user connected: Prod:SYS> select type, count(*) from v$session group by type; TYPE COUNT(*) ---------- ---------- USER 1 BACKGROUND ...


1

As long as the developers only have that role in the development database instance, I see no problem; far better to tune now than later. Now, if your development machine has limited resources, there may be a reason to limit access. But in general, usually tuning tasks run from a few minutes to the default maximum of 30 minutes; during that time, Oracle may ...


1

SESSIONS Default value Derived: (1.5 * PROCESSES) + 22 ... Oracle uses the default value of this parameter as its minimum. Values between 1 and the default do not trigger errors, but Oracle ignores them and uses the default instead. If you want to decrease sessions, you need to decrease processes as well. Still, if you decrease processes, ...


0

The to_date function creates a date with a time. If I remember well this is 12:00. If the date in your table has a different time then this is also taken into account. When you want to test dates then you better put the trunc() function around your date like: select as_of_dt from budget where trunc(as_of_dt) <= to_date('2016-05-15', 'yyyy-MM-dd'); ...


1

First of all do not use database links for larger transactions. This can cause too many problems with blocking sessions. Another hint is to keep transactions in a good size (not to small, not to big). If your table is not partitioned then write a piece of code to remove just 1000 rows, commit and delete the next 1000 rows. You said something about alter ...


-1

oracle SQL statement "CREATE DIRECTORY Mydir AS 'C:\Users\osman\Desktop\Export';" can't create any direcotry on Windows or Linux, it's just a mapping between variable Mydir and directory 'C:\Users\osamn\Desktop\Export' so you need to make sure your windows has 'C:\Users\osman\Desktop\Export' hope this can help you !


2

Kris Johnston said in a comment: nomount/mount/open are the states of the database... something can't connect to the db one way and connect as nomount, and connect to the same db a different way and connect as mount or open. It doesn't work like that. It sounds like you are connecting to a different database altogether. To check, verify the dbid's are ...


0

To connect to RMAN from the operating system command line and hide authentication information, you must first start RMAN and then perform either of the following actions: Run the CONNECT commands at the RMAN prompt. ... Run a command file at the RMAN prompt that contains the connection information.


-3

On 10g version, i use -debug. Ex D:\SW_Imgs\Oracle\10201_database_win32\database>setup.exe -debug


0

So you want to concatenate multiple rows and columns into a single string, just to parse it later. Overhead 1. Next, you want to write PL/SQL for something that can be easily done in plain SQL. Overhead 2. Something like this (I just used random views for the 7 data source): select listagg(x, '|') within group (order by null) from ( select 'COL11' || ...


0

create another procedure with passing paramaters in it schedule the above procedure with creare job CREATE OR REPLACE PROCEDURE XX_COPY_SALES_ORDER IS RETCD NUMBER; RETBUFF VARCHAR2(100); BEGIN XX_PROCESS_PKG.MAIN (RETCD,RETBUFF,NULL); END; BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name ...


4

ORA-00913 too many values Cause: The SQL statement requires two sets of values equal in number. This error occurs when the second set contains more items than the first set. For example, the subquery in a WHERE or HAVING clause may return too many columns, or a VALUES or SELECT clause may return more columns than are listed in the INSERT. Action: ...


-1

Just copy your table with a new name and apply the partioning, drop the original table and rename the copied file to the original table.


0

Actually your query doesn't return anything in my test :(. The reason is the attendance_date doesn't fall in between the condition that you have specified(To_date('05','MM') and To_date('05','MM') is returning the same value). You can change your code as ...where attendance_date between To_date('05','MM') and To_date('06','MM'); to select all the ...


0

If you sort by dates formatted in DD/MM/YYYY, then the sorting will put all the first of month first (of every month), then the seconds of month, etc. You can't sort by a column not included in a select distinct, though. To sort by ascending date, group by and use the actual date column instead of the formatted date via to_char: select To_Char ...


0

SELECT p2.ID, p2.NAME FROM person p1 INNER JOIN person p2 ON p1.ID = p2.ID+1 WHERE p1.ID <> p2.ID AND p2.ID <> 1 You can join the table on itself having ID = ID+1 The AND p2.ID <> 1 should only be there if 1 is the lowest value in the ID column. SQLfiddle example


1

Oracle supports LAG so you should be able to do something like. SELECT T.ID, T.NAME FROM ( SELECT ID, NAME, LAG(ID) OVER (ORDER BY ID) AS PREVID FROM YourTable ) T WHERE ID > PREVID + 1; To compare the Id with the previous one and only return ones with a gap greater than 1. (Untested as SQL Fiddle is currently returning errors ...


0

Sorry it was a such a dumb thing to ask, but again if this is a dumb answer please feel free to delete it. I've used the intersect instead of inner joining the two queries as subqueries.


0

That is just the paging in SQL*Plus. By default the paging value is 14, that includes a blank line at the start of each page, the line with column headers, the line with heading separators (hyphens) and the rest (11 rows) is for user data. If you increase the pagesize, the result of your query will fit in to 1 page: set pagesize 20 It has nothing to do ...


1

Whenever you create a table with constraints in Oracle, an entry is made into the user_constraints table and if constraints involve creation of an index (like in this case, primary key constraint also creates a clustered index), an index is also created on the table which you can find querying user_indexes. select * from user_constraints where ...



Top 50 recent answers are included