QuanwenZhao
Rich Eisen Show 🤖got a question for @[email protected]?
lay em on us!
Ask TOM for Database/SQLOften viewed on #AskTOM: Export into pre-existing schema https://asktom.oracle.com/pls/apex/asktom.search?tag=export-into-pre-existing-schema
Export into pre-existing schema - Ask TOM
Export into pre-existing schema Hi tom,I have a schema export with expdp with this -expdp user/passwors@test directory=dump_dir dumpfile=user.dmp logfile=user.log schemas=userUser have 100 tables 50 procedures and triggers now I want to import this on dB how to import it if the user already there with tables and proced
Often viewed on #AskTOM: Relation between SCN and checkpoint SCN https://asktom.oracle.com/pls/apex/asktom.search?tag=relation-between-scn-and-checkpoint-scn
Relation between SCN and checkpoint SCN - Ask TOM
Relation between SCN and checkpoint SCN Hi Tom,I have gone through many of your threads regarding SCN and I have a few questions regarding them.1. Is SCN generated only for committed transctions and that is when the transaction is committed not when the transaction is begun, right ? A) If so, if the redo of that transaction is
Often viewed on #AskTOM: datafile block fractured https://asktom.oracle.com/pls/apex/asktom.search?tag=datafile-block-fractured
#AskTOM Just answered: Conditional unique basing upon existing data http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:9547449400346575418
Conditional unique basing upon existing data - Ask TOM
Conditional unique basing upon existing data Hi All,I am trying to build a conditional unique key constraint where based on specific data availability, I need to allow duplicates or no duplicates. Ex: I get to insert data with deptno=30 and deptname =SALES; then I can have EMP=123 with more than one record whose DEPTNO=30. emp
Often viewed on #AskTOM: Wildly inconsistent CTE (WITH clause) performance https://asktom.oracle.com/pls/apex/asktom.search?tag=wildly-inconsistent-cte-with-clause-performance
Wildly inconsistent CTE (WITH clause) performance - Ask TOM
Wildly inconsistent CTE (WITH clause) performance I was a SQL Server guy until a few weeks ago. I'm trying to avoid temp tables since there are (amazingly) no local temp tables in Oracle and using global temps to break a query into steps is apparently frowned upon, or at least not an Oracle 'best practice' (https://asktom.oracle.com/pls/asktom/f?p
#AskTOM Just answered: JSON column for application settings http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:9547493400346086564
JSON column for application settings - Ask TOM
JSON column for application settings I wanted your opinion on the best way to store application settings. I've read the following on Ask Tom which recommended the attribute-value pair approach:https://asktom.oracle.com/pls/apex/f?p=100:11::::RP:P11_QUESTION_ID:9538379900346218883In my case, we are building a SaaS solution and
Often viewed on #AskTOM: RR Date format for two digit year https://asktom.oracle.com/pls/apex/asktom.search?tag=rr-date-format-for-two-digit-year
RR Date format for two digit year - Ask TOM
RR Date format for two digit year I have a case where RR date format is not returning expected result... to_date('960504','rrmmdd') returns 2096, not 1996.I seem to recall back in Y2k an inti parm that influenced the action of the RR format.... but I can't find it. Am I imagining this?