29/12/2017 11:47
Group, I was wondering how other people have their servers configured when there is more than one DBA working on the server/database.
For example things could be a lax as all DBAs can use the oracle unix account and login with a generic DBA account. Another option would be each admin has their own OS user id and is a member of the DBA group, but also has a Database account with DBA privs. ( which seems redudant because if you are a member of the DBA group you can always connect / as sysdba.
I.... read more

2 answersclick here to view

28/12/2017 11:47
Hi Does anybody know how to restore a database? Lets say I create database 'testing'. IN that db I create the table test (id, name). Then I make a few inserts in that table.
After a day I truncate that table. But I realize that it was really wrong.
If I go through phpmyadmin and try to export the database, I will see the structure of the tables, but not the data. Neither the inserts or the truncate directive.
In worst cases I can maybe access the database through the console. But right n.... read more

2 answersclick here to view

27/12/2017 11:47
I have a program I'm working on that does has a graph to show what isthe future estimate of production of eggs from a bunch of differentfarmers.
The table I have is this: CREATE TABLE `henbatch` ( `henBatch_ID` int(11) NOT NULL auto_increment, `Barn_ID` int(11) NOT NULL, `Quantity` int(11) NOT NULL, `StartDate` date default NULL, `SlaughteredDate` date default NULL, `StartDateSet` tinyint(1) default NULL, `Received` tinyint(1) NOT NULL, PRIMARY KEY (`henBatch_ID`)) StartdateSet is .... read more

4 answersclick here to view

26/12/2017 11:47
Hi All I am restructuring a company's DB and web-based ordering system. TheDB contains separate tables for1. Users (who may or may not be customers and/or users)2. Customers (who may or may not be customers and/or users)3. Contacts (who may or may not be customers and/or users).
Part of the restructure involves enabling current customers to view/edit their orders and details online where previously only Users (whotypically staff) were able to do this.
Question: Should the redesign: a. Kee.... read more

1 answersclick here to view

25/12/2017 11:47
I'm trying to import all the schemas* from our production database intoa new instance (which will eventualy beome the new production databaseonce I get it all to work).
On the new installation I create the database, create the tablespaces,create the users/schemas giving them quotas on the tablespaces theyneed. So far so good.
Next I want to run import - how many passes is typical for this? Iunderstand I can't do it in one pass, beause I'll be trying to grant rights to objects tha.... read more

7 answersclick here to view

24/12/2017 11:47
oracle 11.2. / on windows I need to import a select list of tables & packages from a schema on asource database I will also need to consider ( perhaps using scripts )constraints/indexes & stats also If anyone can give me any helpfull advice before starting & knownpitfalls to avoid I would be gratefull regardsChris B

1 answersclick here to view

23/12/2017 11:47
Dear all I am little confused about IO controller term used in oracle docs . Can someone explain what is IO controller , is it some hardware card ? orsoftware feature etc ? Waiting for your prompt reply here is extract from the document AQ (Advanced Queuing) operations result in high number of insertionsand deletions from the database. Hence, I/O values on the database will be high andwill need careful tuning. Based on the volume of operations, you may want toincrease the number of I/O controlle.... read more

5 answersclick here to view

22/12/2017 11:47
-------------------------------------------------------------- Software Tree Revs Up JDX OR-Mapper With Innovative And High-Performance Features-------------------------------------------------------------- Software Tree has announced JDX 4.5, the versatile and patentedObject-Relational Mapping (OR-Mapping) software that significantlyaccelerates the development of Java/J2EE applications by eliminatingtedious, low-level SQL coding for persistence. The novel feature ofOneClickR.... read more

4 answersclick here to view

21/12/2017 11:47
We have sales data for products on a year basis for a 5 year forecast. For year 1 we add the base price + shipping + tax to get the total price. that total price then becomes the base price for the next year. so for product A1 we have the following name base_cost shipping tax total year A1 10 0 3 15 1A1 15 2 1 18 2A1 18 .... read more

2 answersclick here to view

20/12/2017 11:47
hi guys...
im preparing for the oca exam on oracle database 10g administration 1.
im starting from scratch, meaning, i dont have any background onoracle. i have oracle 10g in my laptop running in windows xp proplatform. my question is: do i still need to setup oracle in a unixplatform, or preparing for the exam using windows is ok? would there bequestions in the exam pertaining to unix only? thank you very much foryour help.

2 answersclick here to view

19/12/2017 11:47
Hello I have separate tablespaces for indexes and tables. I have rebuildthe indexes and it has changed the used space of index1.dbf file but at thesame time it has also changed the used space of datafile in which the tablesdata reside. I have checked in DBA studio that the percentage used for thedatafile in which the tables reside has dropped from 90% to 70% used. Is itnormal when we rebuild indexes that it cleans the unused space in thedatafile in which the tables reside or what could .... read more

1 answersclick here to view

18/12/2017 11:47
All, Oracle 9.2.0.8OS - HP Ux 11.23 We have table Tcount(*) = 31414748 table definition create table T ( OBJID NUMBER, DEV NUMBER, NAME VARCHAR2(20 BYTE), VALUE CLOB, CONTEXT_INST2GROUP_INST NUMBER, CONTEXT_INST2PROC_INST NUMBER) Table segemnt size =select segment_name, bytes/1024/1024/1024 from user_segmentswhere segment_name='T' 2 / SEGMENT_NAME-----------------------------------------------.... read more

5 answersclick here to view

17/12/2017 11:47
I have a statspack report that shows 0.53 logins per second in theLoad Profile section but in the Instance Activity section of thestatspack report it shows 640 logons cumulative. It was a 20 minutesnapshot so 0.53 logins per second works out to over 2264 logins. Anyone explain the descrepancy? The reason I'm asking is that mostall of the SQL being utilized is having to go through soft parsing andI can't figure out why. If there are indeed 2264 logins that mightexplain all the soft par.... read more

2 answersclick here to view

16/12/2017 11:47
Is there an RSS or other type of automatic feed that announcesupgrades, patches, etc? I would like to find an easy way tofollow upgrades so that I can discuss knowledgably with ourDBA about which ones might apply to us.
Many TIA!Mark

2 answersclick here to view

15/12/2017 11:47
Is it possible to have dynamically aliased columns in a selectstatement without using dynamic sql? I'm wondering if there is a way to do something like the following: SELECT <fieldname> AS <package_name>.<constant> FROM <table> Thanks in advance.
--Mike

3 answersclick here to view

eDiscover
Helpforce eDiscover provides technical articles updated each day
Click the logo to go back to the main page
Databases

Helpforce eDiscover RSS feed contains the latest technical articles in RSSWe have a vast archive of technical informationWe have a vast archive of technical informationA database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. This category deals with general databases and more specific vendor products such as MySQL and Oracle.

Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS