• Truncate or not Truncate SQL

    What are the pros/cons of truncate a table export/import to just drop table?

    Jay Dog5 pointsBadges:
  • ASM State in GMON Trace File

    Oracle 10.2.0.3 RAC using ASM: Red Hat Enterprise 2.6.9.44 (RHEL 4.4) I have having problems bringing up a diskgroup in ASM. When I try to mount it, ASM hangs. When I review the GMON trace file, it shows the diskgroup trying to mount and is says "Member state = 4". What's a member state and what...

    Dwaltr900 pointsBadges:
  • My Oracle server is corrupt, and can’t start using Oracle 8i

    Hi, We have a database that is running oracle 8i on windows 2000 server, but unfortunately it seems corrupt. our intension maybe would be to re-install the database on another machine and migrat all the applications. please give us a guided approach to this problem, the database name DBCAB. Is it...

    Schinama15 pointsBadges:
  • How to import .doc files into Oracle 10g

    I am using Oracle 10g, and i have around 500 tables sitting in .doc file. How can i import those tables into Oracle 10g. Please help me out with this issue.

    System Analyst5 pointsBadges:
  • view color codes

    Hello... i m beginner in lotus notes and would like to know how to change/set color code to particular row in the view based on formula or condition...?? For ex. if the column value is vacant i have to set green color for that entire row in the view. if the column value is occupied it should red in...

    NotesBeginner5 pointsBadges:
  • What is the PRAGMA_INIT exception?

    What is the PRAGMA_INIT exception? Thank you.

    OracleATE190 pointsBadges:
  • Running RMAN (Oracle 9.2.0.8 Enterprise Edition) over network fails with ORA-12560

    Running RMAN (Oracle 9.2.0.8 Enterprise Edition) over network fails with ORA-12560 - TNS Protocol Adapter error. In RMAN cmd file I've tried re-directing to OraHome with \dev-oraclec$oracleora92 as well as directly to the mapped drive: Z:oracleora92. Both fail with same error. I also set...

    OracleATE190 pointsBadges:
  • What more do I need to do to get instant client working with IIS?

    I have installed instant client on my XP computer and am able to connect to a remote Oracle 10g server with SQL plus using this string: sqlplus myid/mypassword@//server:port/svc I have also been able to make a DSN file that connects, and have been able to connect with Visual Basic. I HAVE NOT been...

    OracleATE190 pointsBadges:
  • Oracle Application Express Item

    I have two tables with parent-child relationship. Is there a way to automatically populate the foreign key field of the child table with the exact data from the primary key of the parent table?

    Rwy265 pointsBadges:
  • Report not running in web layout for Oracle 9i

    hello we recently have migrated from oracle 6i to oracle 9i. my problem is that when i compile and run a report (that was built in reports 6i) the web layout in reports 9i is not displaying. the paper layout version is working fine but i need a web layout which is not working. its not giving any...

    Rakh80 pointsBadges:
  • Oracle View

    How can I get my view to return SYSDATE-4 hours? I currently have WHERE event.cdts = TO_CHAR (SYSDATE, 'yyyymmdd')is creation of the view. It is not returning anything.

    Dbawiz5 pointsBadges:
  • Hyperion 9.2 Schedule Error

    As soon as we tried to click 'when to run' on workspace, a listing of error msgs appeared on the screen. Eg. An exception was thrown: null... With the following stack trace....

    Mcha1435 pointsBadges:
  • Oracle listener

    Hi all, can you help regarding oracle 10g listener?Sometimes for no reason i cannot log on int database, and then found there is two listeners running at the same time, do you know why?

    261715 pointsBadges:
  • Upgrade OS system & Oracle

    I am upgrading the OS from Windows 200 Server to Windows 2003 Server both Enterprise Editions. Is there any place I can read about how to get the existing Oracle Database onto the Windows 2003 Server.

    Grabber60 pointsBadges:
  • Oracle DBA or SAP Basis Administrator?

    I completed M.Sc Computers in 2000 but did not get a chance to work in software field till sep 2007. Now I am working in a software firm as Senior software engineer supporting Peoplesoft. Prior to this job I worked for a reputed BPO.My current job role activities are almost similar to a DBA and...

    SAP vs. Oracle5 pointsBadges:
  • list sales by year

    You are to generate a set of sales reports using the tables above. 1) Build a rpeort of sales by year (you can use order total colum) 2) Expand this to include the employee name of the sales rep so now you will show sales by rep by year 3) Also get the sale reps job descriptio and see what type of...

    Kkd7775 pointsBadges:
  • Duplicate Spatial Data

    I"m looking for some help on how to find duplicate geometry for area, line and point features that are stored in an spatial SDO database. Any help would be greately appreciated. Regards, Sam

    SamAvella30 pointsBadges:
  • Moving oracle database

    HI, We have planned to move our oracle 10g production database from Solaris to Aix bix. So experts, please suggest any best practices that you follow or any scripts that should be run before moving it or any documentation or case study that will help us to do the work more efficiently. Thanks a lot.

    8320 pointsBadges:
  • performance tunning

    Dear sir/mam, From last 2 weeks,ur database performance id very slow.plz guide me how to solve the problem. i giving ddetails of spreports,it may be help to resolve the problems. give me solutions as soon as possible. STATSPACK report for DB Name DB Id Instance Inst Num Release OPS Host...

    PERFORMANCE TUNNING5 pointsBadges:
  • SAP HR

    Hi, what are the tables in SAP HR to select the name and salery with sql on oracle

    Wolloc5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following