Last Modified Timestamp Of A Table
Jul 8, 2013Provide me a query to find the last modified timestamp of all the tables present in a schema?
View 5 Replies
ADVERTISEMENT
Find Details Of User Who Modified Structure Of Table?
Aug 3, 2011I have a small question is it possible to find the details of a user who modified the structure of a table, including what command he ran to change the structure of the table?
View 2 Replies View RelatedServer Administration :: How To Know Which Table In Oracle Updated / Modified
Jul 29, 2010I use oracle 9i. After doing execution ,process, how can I know which table in the oracle have been update/modify?
View 18 Replies View RelatedGetting Timestamp For Existing Records In Table?
Nov 15, 2010I need to get the timestamp for all the existing records in my table...I am having one user definition field, is this possible?
View 4 Replies View RelatedSQL & PL/SQL :: Pivot Table Using UNIX Timestamp
Feb 23, 2010I am trying to produce results in pivot format. I want to know how many entries per day per month. In other words how many entries on a Monday for each month, how many on a Tuesday for each month and so on.
The main problem I have is that the date column in the database uses UNIX time stamp. I have managed to get the results I want for a particular month. This code selects the entries for last month.
select
max(decode(pdayno, 1, cnt, null)) Sunday,
max(decode(pdayno, 2, cnt, null)) Monday,
max(decode(pdayno, 3, cnt, null)) Tuesday,
max(decode(pdayno, 4, cnt, null)) Wednesday,
[code].......
This code produces the result:
What I need is for another column at the start of the results to give the month so I end up with 12 rows, 1 for each month.
I did try to group by PENTERED(which is the unix time stamp column)
select pentered,
max(decode(pdayno, 1, cnt, null)) Sunday,
max(decode(pdayno, 2, cnt, null)) Monday,
max(decode(pdayno, 3, cnt, null)) Tuesday,
max(decode(pdayno, 4, cnt, null)) Wednesday,
[code]......
This gave me thousands of rows as each UNIX time stamp is unique. Is there a way of grouping on UNIX time stamp.
One Table With A Columntype Timestamp Say Xyz Is Name Of Column
Sep 16, 2012I have one table with a columntype "timestamp" say xyz is the name of the column.Suppose today is 15th Sept So I want to fetch all those records whose value is between 14th Sept 00:00:00 and 14th Sept 23:59:59.
And date I want to keep this as a variable.
SQL & PL/SQL :: Adding TimeStamp Values In Table
Apr 4, 2011I want to have sum of Time Stamp Values in a Table. i.e. Group by Query
example : Select Name, Sum(Timestamp column) from Emp group by name;
OR
I have Time values in character column of a table. i.e. Table TT column t1 char(5) values '03:02'
Above mentioned values in more than one line, i want to get the sum of all the values and it should be a time value.
Replication :: Timestamp For A Table For Conflict Resolution
Aug 25, 2008I have a question about the timestamp conflict resolution. let me describe my question with making an example:
I have a table(test1) with 3 columns(a,b,c)
I do also have 3 column groups one for a ,one for b and one for c if i want to use timestamp conflict resolution for b and c should I add 2 column timpstamp1 and stimestamp2 to test1 for each of these columns and define 1 trigger for each of them?
I hesitated because if it is true and for example if we have lots of columns which need timestamp conflict resolution the size of our table become very big.Is it correct?
How To Know Exact Time Of Row Modified And Deleted
Jul 16, 20101)How can i know that in a table when i modified a row or deleted a row and which row i inserted when i want to know the particular time
can it is possiable if possiable then tell me how.
2)Is there any difference between 9i merge and 10g merge command ?
SQL & PL/SQL :: Get Last Updated Date When Data Modified?
Jun 20, 2011I have multiple project databases where their tables are similar. I wanted to know just a single date from each project databases is modified/updated. If I run a query like select * from component order by eng_proj_id, chg_date desc then it will return many records sorted by their eng_proj_id and chg_date in their descending but I only need just a single record with last update from each project databases.
View 13 Replies View RelatedSQL & PL/SQL :: Find Date When Attributes Modified?
Sep 14, 2012The requirement is to find the last date when either ATTRIB1 or ATTRIB2 were modified for each ID. There are many other columns in the table, but I'm not interested in other columns.
Test Case
SET LINES 100
SET PAGES 100
DROP TABLE test_log
/
CREATE TABLE test_log
[code]....
Expected Output
ID LAST_CHANGE_DATE
---------- --------------------
11 02-SEP-2012 10:58:32
35 05-AUG-2012 10:58:32
I have written the below query, to get the required output.
SELECT MAX(i_date) last_change_date
FROM
(
SELECT seq,id, attrib1, attrib2, i_date,
row_number() OVER (PARTITION BY attrib1 ORDER BY i_date) rn1,
row_number() OVER (PARTITION BY attrib2 ORDER BY i_date) rn2
[code]....
PL/SQL :: Logs Of Modified Database Objects
Jul 25, 2012i have a sequence for one of my table that this sequence's current value was 3000 yesterday but today when i checked current value of it, i surprised because the value changed to 50, can i check who changed my sequence? is exists any data dictionary that shows logs of modified database objects.
View 3 Replies View RelatedPL/SQL :: Check Date Of Last Modified Procedure?
Oct 17, 2012 how to check last modified function or procedure.
for example: INVO_75.PCK.PrintInvoices_fct
PL/SQL :: How To Find Who Modified Package Code At Last
May 13, 2013how to find who modified a package code at last? I can only find the latest modified date with USER_OBJECTS.
View 3 Replies View RelatedEnterprise Search :: Last Modified In Web Source
Jul 13, 2012I have created a web source with the default settings and pointed it at a test site. The pages being craweled have both last modified response headers and meta tag last-modified being set in the rendered html but the crawler doesn't seem to be indexing the values.
It is indexing and returning last modified on the liked files (i.e. *.doc, *.pdf) but not the actual web page itself.
Am I missing a step? How do I get the last modified meta tag of html to be indexed?
ORA-02097 / Parameter Cannot Be Modified Because Specified Value Is Invalid
Jun 21, 2012pga_aggregate_target has been incorrectly set to 21gb in one of our databases.
SQL> sho parameter pga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 21686M
When I try to change it to 1g or 800m I get the following error.
SQL> alter system set pga_aggregate_target=1g scope=memory;
alter system set pga_aggregate_target=1g scope=memory
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00068: invalid value 104850 for parameter smmmax_size, must be between 0 and 0
Whereas when i try to set the scope to spfile it works
SQL> alter system set pga_aggregate_target=1g scope=spfile;
System altered.
Version is 11.2.0.3 on RHEL 5
how I can set the pga_aggregate_target right, I am not sure whether bouncing will work or not since i m doubtful that I may get the same error related to smmmax_size while bouncing with the new pga_aggregate_target.
Forms :: How To Downgrade (FMB) Created / Modified In10g To Version 9
Aug 21, 2013We have Forms application created in Oracle Forms Builder version 9.0.4.0.19. We have done modification in some forms and few forms created using Oracle Forms Builder 10g version 10.1.2.0.2.
Now we need to convert those forms which are around 5 or 6 in number to Oracle Forms 9.
SQL & PL/SQL :: ORA-30556 - Functional Index Is Defined On Column To Be Modified
Feb 2, 2012I'm altering a column length to increase the size and getting "ORA-30556: functional index is defined on the column to be modified".
On searching more about this error, it seems like the function index must be dropped before altering the column.The table I'm dealing with is huge.
Question 1:In case of dropping and recreating the index, should the following steps be done:
- Drop Index
- Alter the column to increase the size
- Recreate the index with NOLOGGING and NOPARALLEL clause
- ALTER INDEX to turn on LOGGING
- Gather Statistics on that index
Question 2:Is there anything else that should be done when the index is dropped and re-created?
Question 3:What are the side-effects of carrying out the above steps in a huge table with around 15 million rows?
Question 4:Would it work if I disable the index, alter the column and reenable the index?Do I have to rebuild the index and gather Stats upon reenabling it?
Forms :: FRM-40202 - Field Must Be Entered (after Standard Form Had Been Modified)
Apr 14, 2010I got an error FRM-40202: Field must be entered. I did some modifications to Standard form by copying it. after that when I selected the first Email check box in the list and then selected the Email button which I created newly for that form.
View 1 Replies View RelatedServer Administration :: Modified Objects - Compare Two Users On Different Databases
Oct 2, 2012I want to compare two users on different databases, actaully there are two users one in user a on database a and another user b on database b they have same tables, and everytime when a table or object is created on user a (database a) i will take the table name ,procedure or any other object from user_objects based on ddl_created date and then i need to recreate the same on user b on database b, is there a way to find out tables which are not only created but also i need to check whether if there is any column added or any change in procedure or any other objects.Is there a way to generate the scripts based on list of objects selected from user_objects.
all i want is.
a)Find out the list of objects added along with creation scripts
b)find out the list of objects modified along with creation scripts.
Server Administration :: Trace IP Address And OS Username / Service IP Who Modified Objects?
Sep 4, 2011I have a problem some user modified the objects and now objects became invalid .How to trace the ip address and operating system username and service ip who modified the objects?
View 3 Replies View RelatedApplication Express :: ORA-01439 / Column To Be Modified Must Be Empty To Change Datatype
Sep 4, 2012I need to modify the column type that already has data in it, i need it change varchar to number then The datas entered have $ and , (e.g $3,200). I need the $ and , removed with column type set to numbers.
When i currently do this i get the following error:
The TABLE operation was not successful for the following reason:
ORA-01439: column to be modified must be empty to change datatype
I've tried unloading the data and loading the data using the spreadsheet, cut and past and csv file but both give me more errors, so i just want that one column modified.
Timestamp From A Row
Oct 17, 2012I am working on a table what has duplicate id with different data set. The problem is this table does not have any time stamp. and this table is created long ago. now I need to remove those records with duplicate id. I want to keep the oldest one. How can retrieve the time stamp of those old data.
View 7 Replies View RelatedSQL & PL/SQL :: Timestamp To Date
Jul 26, 2011From ETL to Oracle, I have stored the timestamp in varchar2 as '30-MAY-11 06.30.00.000000 PM'. Now I need to convert this varchar2(timestamp format) to date. I used:
select TRUNC('30-MAY-11 06.30.00.000000 PM','dd/mm/yyyy hh24:mi') from dualBut, it doest work. get date format?
SQL & PL/SQL :: Use Of Sub Seconds In Timestamp
Feb 11, 2011What is the exact usage of the SUBSECONDS in Timestamp data type.
Especially it has range upto 9 decimal places?
SQL & PL/SQL :: Create Trigger For Timestamp
Aug 13, 2010Create a trigger that stamps the date_created and the date_updated column with current date on new and updated records?
View 2 Replies View RelatedSQL & PL/SQL :: How To Subtract Minutes From Timestamp
Mar 31, 2010I need below proc like...
procedure p1
(
i_time_min number -- minutes to be substracted from timestamp
)
is
v_end_timeinstamp timestamp(6);
begin
[code]....
The problem with above procedure is passing parameter is in minutes and i need to substract the same from sys_extract_utc(current_timestamp) and store result in v_end_timeinstamp in timestamp format only... substracting directly will reduce the days and not the minutes.
SQL & PL/SQL :: Fraction Of Secs In Timestamp
Mar 12, 2011where exactly the FRACTION of seconds being used, in the TIMESTAMP Data Types.
Example in the below result.
CURRENT_TIMESTAMP
-----------------------------------------------------------------12-MAR-11 10.35.39.691342 PM +05:30
SQL & PL/SQL :: How To Pass Timestamp Parameters
Sep 13, 2013In my task I am trying to pass a timestamp datatype as one of the input parameter to a procedure in the package.But I am not sure how to give data for it while executing and testing it from anonymous block.
CREATE OR REPLACE
PACKAGE body ac
IS
PROCEDURE ac_ex_wbdb_keycats(
In_Sale_Location_Id IN NUMBER,
In_Start_Datatime IN TIMESTAMP,
In_Stop_Datatime IN TIMESTAMP,
v_refcur OUT sys_refcursor)
[code]....
SQL & PL/SQL :: Extracting Date From Timestamp?
Jan 18, 2012How to extract date from a timestamp data
for example
Input-15/06/2010 05:30:00.000000
output: 15/06/2010
