Auto Rotation Table

Nov 18, 2010

Is there any strcuture or fucntion that can make the table have something like rotation.

I mean the record can be first in first delete.

So,for example , even the table have limit row for example , 100 row .

so, the new data can be replace the oldest row in the table auto and insert into the table .

so the new row will replace the oldest 99 th row auto .the table still keep 100 row but the data can be update .

Is it "partition" or other ??

how can I create it .

View 4 Replies


ADVERTISEMENT

SQL & PL/SQL :: Auto Rotation Table In Oracle

Nov 18, 2010

Is there any strcuture or fucntion that can make the table have something like rotation.I mean the record can be first in first delete.So,for example , even the table have limit row for example , 100 row .so, the new data can be replace the oldest row in the table auto and insert into the table .so the new row will replace the oldest 99 th row auto .the table still keep 100 row but the data can be update . Is it "partition" or other ??

View 8 Replies View Related

Alert Log Rotation / OS Audit Log Rotation

Aug 23, 2013

Is there away  that I can fix of my audit and alert log size to 100Mb and it will just reuse or rotate around it?Or can manipulate it thru  OS programs?

View 3 Replies View Related

SQL & PL/SQL :: Auto Generation Of Number

Feb 27, 2013

Need to generate auto number as below

A00001 to A99999. After A99999 it should begin with B00001 and ends with B99999. till Z99999 we need to generate.

View 1 Replies View Related

SQL & PL/SQL :: Auto Number For Primary Key

Feb 19, 2011

I have set up a schema using a DDL script in Oracle 10g. I am linking this through to a Visual Basic 2008 fron end. The connection is fine. My database of is for a car hire company project.

I need to know how to create an auto increment for a primary key field, like Access does.

For example here is my table structure for my Rental_Payment table.

-- TABLE RENTAL_PAYMENT
CREATE TABLE RENTAL_PAYMENT (
PAYMENTNO NUMBER NOT NULL,
CARDNO NUMBER NOT NULL,

[Code]....

So for example the first record would appear as:

PAYMENTNO CARDNO AMOUNT CARD_TYPE
======== ===== ====== =======
01

I would then enter values and the next payment number would be 02 etc.

PAYMENTNO CARDNO AMOUNT CARD_TYPE
======== ===== ====== =======
01 123412 £40.00 VISA
02

Visual Basic will usually have a star (*) beside a new entry field so 02 will be
* 02

etc........

I have about creating a sequence. So how can I tie this to my table?

View 12 Replies View Related

SQL & PL/SQL :: Auto Update Trigger

Apr 2, 2012

I have 2 tables where the data is related.table ot_pack_list,ot_delv .ot_pack_list contains details of items information that are packed to be delivered sometimes what happens user may remove some items from this, and the summary column of dl_wt and dl_qty in ot_delv must get automatically changed whenever there is addition in ot_pack.

create table ot_pack_list (item varchar2(12),pack_qty number,pack_wt number,pack_no number)
insert into ot_pack_list values ('a',2,10,1);
insert into ot_pack_list values ('b',3,55,1);
create table ot_delv (d_no varchar2(12),d_qty number,d_Wt number,d_pack_no number)

[Code]...

--after updating the data in ot_delv should be like..

select * from ot_delv;

d_no d_qty d_wt d_pack_no
----- ----- ---- -------
1 5 75 1

View 15 Replies View Related

SQL & PL/SQL :: Auto Increment Column

Aug 11, 2010

I have a table abc with name and phone_number columns in it,and this table contains 100 records. Now I want to add a column say ID as primary key for this and it should be auto incremented and should have primary key for the first 100 records as well.

View 8 Replies View Related

Standby Auto Startup On OEL 5

Sep 14, 2012

I have to make this script . It should be something like this :

starting of lsnrctl.......
startup mount;
alter database open read only;
recover managed .....................;

and a second script is to shut down everything correctly during Linux shutdown..I think it would be better to make a new Linux service . make a whole script? Oracle 11.2, Oracle Linux 5

View 2 Replies View Related

Tablespace Auto Extend

Dec 26, 2012

What does mean AUTO EXTEND ON ? What is purpose ?

For eg :

I'm creating a table space with 5M size . i can insert rows still 5M getting fulled then what is the purpose of autoextend ?.

I'm reading documented but couldn't understand clearly..

View 4 Replies View Related

SPM Auto Load Capture And Use?

Sep 12, 2012

I was reading about Oracle SPM feature, but i have questions in mind for automatic feature..

* if we have set both capture and use parameter true. Oracle will automatically capture Plans, but will it automatically evolve new plans to accepted or it will wait for evolve it manually before using new plan.

* If it Automatically evolve, when and how will it?

* If it Automatically, will change old plan's flag accepted to No? or add one more accepted plan

View 9 Replies View Related

Forms :: LOV / Auto Select Values

Apr 13, 2012

I have an LOV on my form which holds a list of course units for a student to select and insert. However some units on the LOV must be COMPULSORY(not optional).... so i was wondering is there a way to have these auto selected from the LOV?

View 4 Replies View Related

RAC & Failsafe :: How To Set Auto Startup When OS Start

Mar 24, 2012

I have installed a rac database,when the os start,and the database can not auto start,how to make the database auto start when OS start?

View 1 Replies View Related

SQL & PL/SQL :: Can Auto Extend Work With Quota

Apr 9, 2012

I have given a specific user default tablespace on Users and a quota 5M. However I want to check if the user have used up 70% of that 5M. If so, I want to increase quota by 500K so in this will be an additional to the 5M. The code I wrote is overwriting the 5M I initially gave the user with 500K. Attached is a sample of the code.

View 14 Replies View Related

Suppress Prompt When Deploying PSU In Auto

Aug 2, 2012

Whenever I deploy a PSU patch I receive the prompt below. I'm attempting to deploy PSU in an automated fashion. How do I suppress the prompt? "Enter 'yes' if you have unzipped this patch to an empty directory to proceed (yes/no):"

View 0 Replies View Related

Security Role And Auto Permissions

May 13, 2013

I have created and role in my database and assign privileges as per following query.

Select 'Grant select on'||' user.'||object_name||' '||'to MyRole ;' from all_objects
where object_type in ('TABLE','VIEW')
and owner='username';

After granting role to new user everything work fine.I want to know a way to sync role with any newly created object.

Should I create a job that may execute above sql store results in a file and then execute to ensure all privileges are up to date for role or there any other optimal way exist ?

View 4 Replies View Related

Oracle Auto Extensible Tablespaces

Jan 7, 2011

I need to create a shell script to find the free space of an auto extensible tablespaces and send an alert when the free space is < 700MB. I tried checking with the dba_free_space, but I did not get the exact free space.

Tell me the logic to find the exact free space of autoextensible enabled tablespaces?

View 1 Replies View Related

Auto Startup Active DataGuard After Reboot

Apr 6, 2011

I try to auto startup my standby database after reebot machine. I used trigger " on startup" , srvctl but still it doesn't work..Database 11g , operating system RedHat 5 or HP-UX.

View 2 Replies View Related

Create Code In A Way That AppID Is Auto Incremented

Nov 16, 2011

I have a database table App, with a primary key,AppID. So I need to insert Data in App, which will auto generate AppID.

My Store Procedure goes something like this:

AppID IN NUMBER
, PersonID IN NUMBER
, ContractorID IN NUMBER
, erfNo IN VARCHAR2
, streetNo IN VARCHAR2

so I need a to create the code in a way that AppID is Auto incremented, and it is a returned value after I inserted values.

View 2 Replies View Related

Update With Case Clause Auto Commits

Nov 26, 2012

i tried the following update on one table:

update siebel.s_contact
set marital_stat_cd =
case
when (marital_stat_cd = 'Casado') then 'Married'
when (marital_stat_cd = 'Solteiro') then 'Single'
when (marital_stat_cd = 'Divorciado') then 'Divorced'
end

As you can see i forgot the else, so my update is wrong.

I thought i could rollback the update issuing the rollback statement, but when i have issue the rollback, the i query the table to confirm that the update was rollbacked and for my suprise the update is commited.

I didn�t issue the commit statement after the update and i confirmed that the auto-commit feature to worksheets is disabled, so i don�t understand whit the update was commited.

View 5 Replies View Related

Forms :: Auto Stretch Functionality In Oracle?

Oct 6, 2013

Is it possible to have auto stretch functionality (similar to Oracle ADF) in Oracle Forms?

The requirement is to adjust the data blocks/ canvases according to the window size automatically.

I know it is possible in Oracle ADF. But I want to achieve the similar kind of functionality in Oracle Forms.

View 1 Replies View Related

Forms :: Auto Refresh When Data Updated

Apr 19, 2010

i need a code to auto refresh or after 1 minute in form & report when the data is updated. basically i am deploying the plasma tv in hall so executive can see the status report where they need its going to be like a stock system multiple forms or reports sticky dynamically change .

View 2 Replies View Related

Server Administration :: When Did A Datafile Auto-extend

Dec 21, 2010

Is there a way to find out when a datafile for an undo tablespace with autoextend enabled actually extended? I've done a few tests, and nothing is written to the alert log or any trace file that I've found. I can't find any V$ or DBA view that will give me the history of a file's size.

View 5 Replies View Related

Forms :: Where To Set Auto Refresh On Custom Form

Dec 14, 2010

How and where to set Auto Refresh on Custom Form ...?

View 1 Replies View Related

SQL & PL/SQL :: Create Trigger Not Working For Auto-increment

Jun 16, 2010

Step1

CREATE TABLE test
(id NUMBER PRIMARY KEY,
name VARCHAR2(30));

Step2

CREATE SEQUENCE test_sequence
START WITH 1
INCREMENT BY 1;

Method1 Follow Step1 and Step2 and create a Trigger as below :

CREATE OR REPLACE TRIGGER test_trigger
BEFORE INSERT
ON test
REFERENCING NEW AS NEW
FOR EACH ROW
BEGIN
SELECT test_sequence.nextval INTO :NEW.ID FROM dual;
END;
/

Method 2 Follow Step1 and Step2 and directly have an insert statement as below:

INSERT INTO test (id, name) VALUES (test_sequence.nextval , 'Jon343');

Method 1, the Trigger is not getting created, however by following Method 2, I am able to generate auto-increment number.

View 8 Replies View Related

ORA-12012 / Error On Auto-execute Of Job 4968

Jul 17, 2007

I have some message for job at any time with any number of job

ORA-12012: error on auto execute of job 4968
ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 6
ORA-00604: error occurred at recursive SQL level 1
ORA-01427: single-row subquery returns more than one row
ORA-06512: at line 6

But when i see job

SQL> select job from dba_jobs;

JOB
----------
92
93
94
95
96
97
98
99
100
9 ligne(s) s�lectionn�e(s).
SQL>

And nothing. I have some message of this in my bdump directory with some different hours.But i want to find what is take this. How i can do to trap this. Because the number of job is not in dba_jobs.

View 5 Replies View Related

ORA-12012 / Error On Auto-execute Of Job 196257

Apr 30, 2013

Getting the below lines in alert_log in bdump.

Mon Apr 29 16:17:32 2013
Errors in file e:oracleproduct10.2.0admindblivedumpdblive_j000_1528.trc:
ORA-12012: error on auto execute of job 196257
ORA-29886: feature not supported for domain indexes

View 3 Replies View Related

Data Guard :: Standby DB Cannot Do Auto Recovery?

Apr 23, 2013

I have done the configs as per the guide here [URL] .... This is a physical standby db

Primary initBP1.ora
compatible = "11.2.0"
log_archive_dest_1 = "LOCATION=H:oracleBP1oraarchBP1arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=BP1"
log_archive_dest_2 = "SERVICE=BP1_DR VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
[code]...

How I do I make sure that the DR site is recovering automatically ?

View 10 Replies View Related

Application Express :: Auto-complete To Combobox - Where Is LOV

Jan 9, 2013

A few years back, most likely under Apex 4.0, I started using Jquery - Autocomplete for looking up employee names, hostnames, etc. This used some Javascript that someone had posted (don't recall who), and it worked pretty well. I would add a stanza like this to the page def (to be run after the page loads). The X02 passed some extra info to the on demand procedure to work with the search.

$("#P28_REQUESTOR").autocomplete('APEX', {
                apexProcess: 'PERSON_SEARCH_ACTIVE',
                width: 600, multiple: false,
                x02: 'Hostmaster:Owner Ok',
             
[code]...

END;The g_x01 value is what the user is typing into the text box - once they hit three characters, it gets sent to Oracle for processing via the on demand procedure. The g_x02 (and 03, 04,..) are additional parameters - perhaps from a parent LOV. General concept with the returned data is the first element is the text to be searched, the second is the actual value (typically an integer - primary key), and the third value is what ends up in the text box once a value is selected (the searching value often has additional identifying info.)

This approach worked pretty well, although it did not play well with cascading LOVs. But once I upgraded to Apex 4.2, I started hitting other issues with jQuery version differences, and some odd failures. To make matters worse, the original developer of the Javascript module, abandoned it - was not doing additional work with it.

Combobox
I did NOT want to re-invent the wheel, and it seemed to be a much better approach to move into PlugIn world - ideally using a plugin that someone ELSE wrote and was maintaining. I looked at the LOV Friendly Autocomplete plug in - and even installed it a few places - and discovered that it did not play well with my earlier autocomplete code.

My concern with using the LOV Friendly Autocomplete - is that I didn't know how to provide any of the "Target Name" search info to the LOV (since that is what is being typed by the user at the time).I also started looking at the Combobox plug in - which seemed even closer with Lazy Loading=Yes (I also liked the ability to add new items on the fly) - but I was not sure how to provide the "Target Name" info the the Pipelined function that generates the list of values.

I want to get rid of all of my old Autocomplete javascript and move to one (or more) plugins - (Which is why the details above don't matter, just trying to provide some background)Is this a good direction (Combobox or LOVFA)? How/Where do I connect my search (lov generation)?

View 0 Replies View Related

Auto Compile Invalid Database Objects

Nov 11, 2013

If i modify any procedure then auto compile should happen dependended objects.

Oracle Version: 10g

View 1 Replies View Related

Auto Accounting Rule Is Not Taking Effect In PROD

Aug 10, 2013

we are in the migration of oracle apps 11.5.9 [version] , while uploading AR open invoices we used auto accounting rule for revenue account , but we did this changes its not taking an effect , same revenue a/c we uploaded is uploaded , but the auto accounting is not taking an effect ,

for a work around we migrated the data ! but we would be the root cause and possibilities why it hasn't worked ?

But this auto accounting rule worked in CRP & UAT as well ...!!!

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved