Vincent Malgrat

2,844 reputation

213

bio	website
	location	Paris, France
	age	33
visits	member for	2 years, 4 months
	seen	3 hours ago
stats	profile views	108

	2,844 reputation	bio	website		visits	member for	2 years, 4 months
213 badges		location	Paris, France		seen	3 hours ago

summary answers questions tags badges favorites bounties reputation activity

260 Actions

suggestions reviews revisions comments badges posts accepts all

May 15	comment	populate table header and data in another table column Sorry I hadn't seen the 10g tag, you'll have to do it the boring old-fashioned way then, or upgrade !
May 15	revised	populate table header and data in another table column added 1977 characters in body
May 15	comment	populate table header and data in another table column @Sanjeev database version? Also it does run, check it yourself :)
May 15	revised	populate table header and data in another table column added 418 characters in body
May 15	answered	populate table header and data in another table column
May 14	comment	Accessing the insert statement which triggers a trigger inside the trigger's body @YasirArsanukaev Nice try, but there is the `DBMS_AUDIT_MGMT` package. I'm pretty sure there is a package/command to manipulate every `sys` objects you need to modify :)
May 14	comment	Accessing the insert statement which triggers a trigger inside the trigger's body `SYS` is a special internal account, you should never issue DDL or DML against its objects.
May 14	awarded	Caucus
May 13	comment	*User with dba privs can't login to APEX, but can from SQLPlus** Apex users and database schemas (users) are totally disjoint.
May 6	answered	*User with dba privs can't login to APEX, but can from SQLPlus**
May 6	revised	*User with dba privs can't login to APEX, but can from SQLPlus** edited tags; edited title
May 3	comment	Timezones in Oracle 10 Oops you're right, I messed up my test case !
May 3	comment	Timezones in Oracle 10 `TIMESTAMP WITH LOCAL TIMEZONE` are set at the server time zone, not the client time zone. Changing session time zone won't change the output of a query.
May 2	answered	Compare dates problems
Apr 19	revised	Find who and when changed a specific value in the database edited tags; edited title
Apr 18	comment	How to permanently delete a row in oracle forever It's incredible how Oracle gets in the way at every step to protect data =)
Apr 18	comment	How to permanently delete a row in oracle forever I would also recommend to move the table to a new tablespace on a new disk drive and procedurally rewrite all the old disks. Else forensic analysis could probably retrieve the old data. Moving a table will only copy logically existing data.
Apr 16	comment	impdp failing with ORA-01031: insufficient privileges Have you seen the MOS note DataPump Import (`IMPDP`) Fails With Errors `ORA-1031 UDI-31626` If DBA Role Is Missing -- ID 1459430.1‌? Using a `DBA` user to perform the import (not necessarily `expenses1`) might solve the issue.
Apr 16	awarded	Citizen Patrol
Apr 12	comment	Oracle's UTL_FILE @Edu it was pseudo code. Here's a complete example.