#DateForumTypeThreadPost
2524 Jun 2010 @ 04:07 PDTDatabaseReplyDnoeth...Need help!!Probably i can save Dieter from replying a basic answer: These can be used for data transfer: 1. Use ARCMAIN (faster) 2. Fast Export/ Fast Load. (fast) Paid solution: 1 Data mover/NPARC (...
2402 Mar 2010 @ 11:17 PSTDatabaseReplyError 3932 while running Vies DDL in SQL assistantI tested succussfully by creating two views( both with WHERE clause) and executing the mcollectily as well as individually. That should not be the problem. Try to explore DDL and Transaction Proc...
2308 Feb 2010 @ 10:48 PSTDatabaseReplyStats CollectionHello Terry Individual collect stats is required initailly at the time of defining table statistics for the 1st time. With that done, ideally 'COLLECT STATS ON TABLE' is used for refreshing the...
2203 Feb 2010 @ 03:31 PSTDatabaseReplyFast Export - Fast Load issueHello Dierter Got the resolution.Not in mentioned scripts but during testing i began using .DATEFORM ANSIDATE command in FAST LOAD script. On reading this from manual: "When you use the ANSID...
2103 Feb 2010 @ 08:44 PSTDatabaseReplyFast Export - Fast Load issueHello Dieter Thanks for the reply. I mentioned RECODE mode in my 1st posting as it is causing issues with source table NULLs by displaying 0 for integer and blank for character in target table (...
2002 Feb 2010 @ 04:13 PSTDatabaseTopicFast Export - Fast Load issueI am trying to do bulk table transfer from production to test box using FAST EXPORT and FAST LOAD. Export is ok with data saved on unix files but while loading data into test box , the null values...
1926 Jan 2010 @ 09:58 PSTDatabaseTopicHeart beat queriesHello I want to know the best practices around heart beat queries such as 1.How many can be termed as sufficient heart beat queries? 2. What should be the ideal frequency of executing them? ...
1801 Dec 2009 @ 09:03 PSTDatabaseReplyquestion about explicit access rights thanks again Jimm...your script is good when we want to know a user's explicit rights either directly or via role where as my question is - how to know which user/role is having explicit rights on ...
1720 Nov 2009 @ 01:00 PSTDatabaseReplyquestion about explicit access rights Thanks Jimm.. But query following UNION is missing table names.. Can you check that..
1620 Nov 2009 @ 09:11 PSTDatabaseTopicquestion about explicit access rights Hi All What I want oto know Iam intrested to know all the explicit access rights on a given table covering individual and role privileges. Say for eg - UserA and RoleA have insert rights on Ta...
1506 Nov 2009 @ 12:39 PSTDatabaseTopicColumn usage historyHi Friends In order to understand PI choice , one criteria is to know the frequency of column access in joins and in WHERE clause. Iam looking out for a script which can give a historical colum...
1428 Oct 2009 @ 10:11 PDTDatabaseReplySkew issuehello Dieter Thanks for your valued suggestion.Here are few sharable points: 1. Source database and target dabase is same, only table name is changing. 2. Database permspace is almost even acr...
1327 Oct 2009 @ 02:32 PDTDatabaseReplySkew issueThanks for the info,in fact I used method suggested by you ( CT dbname.tablename as dbname1.tablename1 with data;) at the 1st place. But the issue remains unanswered.Can anyonethrow some light ...
1226 Oct 2009 @ 03:32 PDTDatabaseTopicSkew issueHi Friends... CT dbname.tablename as sel * from dbname1.tablename1 with data; tablename1 is 70 gb ,and dbname has 110 available space. Query retuned with spool space error, during MERGE step ...
1126 Oct 2009 @ 03:23 PDTDatabaseReplyAllowing access on DBC tables/view. How risky it is?thanks all for your reply...
1016 Oct 2009 @ 03:29 PDTDatabaseTopicAllowing access on DBC tables/view. How risky it is?Hi Friends I wanted to know ,wheather DBC tables/views should be accessable to all the DB users ? What are the risks of exposing the DBC objects to ALL users? What can be a alternative if any?
925 Sep 2009 @ 04:56 PDTDatabaseReplyHow to fetch the data from one server and insert in to other server in SQL Assistance?three solutions:1.Do EXPORT/IMPORT using SQL assistant.2.Do FASTEXPORT/FASTLOAD from source to target system.3.Do source table backup and then restore it on the target system.
825 Sep 2009 @ 04:51 PDTDatabaseReplySubqueries WorkaroundThe above reply is quite a alternative, else a volatile table can be used here.
725 Sep 2009 @ 01:29 PDTDatabaseReplyDesign IssueHiIts a trade off between data distribution and retrival. Surrogate key can be a good PI candidate for data distribution but wont be effective in queries on the table. Thus if the table PI doesnt e...
625 Sep 2009 @ 01:08 PDTDatabaseReplyView breaks on table changeHi All...Below scenrios are helpful in understanding view's behavior with respect to the table change(s).Scenario 1View definition - SELECT a,b,c,d from Table. Action on table : Adding new columns ...
525 Sep 2009 @ 01:01 PDTDatabaseReplyteradata boxIt is very generic term used to specify either production/developement/testing database as the case may be.Say a company is having 3 teradata insatallation (with different configuration of No of no...
424 Sep 2009 @ 07:49 PDTDatabaseReplyData usage benchmarks to identify most used vs least used datayou can do some reserach on DBQL tables
328 Aug 2009 @ 01:36 PDTDatabaseTopicAn important question on viewsViews represent tables. IS there any way to find the name of view for which the base table DDL has changed. A simple method is to run the view, if it throws a syntax error, then we can know that t...
228 Aug 2009 @ 01:31 PDTDatabaseReplyMacros vs Stored ProceduresSPs are more favourable for situation needing procedural workaround not possible by simple SQL.It consume space and have a row by row operation. Macro on the other hand is a collection of many SQL ...
126 Aug 2009 @ 02:02 PDTDatabaseTopicSubquery IssueHello Friends Can anybody educate on the proper subquery functionality.I have a subquery which goes into Product Join in Explain plan. I have remodelled it and there is no more Product join on ...

Pages