• Using Record Type

    We have a table with 70 columns and everyday we move data from thsi table to its history table which is basically same in structure. The daily table has about 4 million records that is tranferred to the history table. To move data from this daily table to the hostory table we are using bulk collect...

    PRASAD550 pointsBadges:
  • Duplicate records

    What is the best way to detect duplicate records within a large database where the primary key is different?

    Squirls0 pointsBadges:
  • DISTINCT or work-around

    Greetings from Vijay, Consider table B as below with columns b1 and b2. Table B B1 B2 ========== 1 abc 2 xyx 3 abc 4 efg 1 xyx 3 abc 4 car 5 edf Query 1 ========= select distinct b2 from B Output : ====== B2 ============ abc car edf efg xyx Explain Plan: Query 1 ===================== Operation...

    Vijaysai0 pointsBadges:
  • Default values in Oracle packaged procedures

    What is the best way to conceal default packaged procedure parameter values? I thought of this way: Make default values NULL in the specification Make default values whatever you want them to be in the package body. Wrap (encrypt hex) package body. I need this in order to obfuscate the use of this...

    NOCOPY0 pointsBadges:
  • NLS Parameters, Character Set Selection for Saudi Arabia

    HI, I need to create a data warehouse in Saudi Arabia, on Oracle 9.2.0. The database will store almost everything in English, but will need to store Arabic names in Arabic, and will need to handle both gregorian and hijri date formats and display them correctly. This same database may later need to...

    Abkeyte0 pointsBadges:
  • Privileges for DBA role

    In an Oracle database I have a user with DBA as the default role. But I had to grant explicitly via "grant SELECT on ..." to this user to allow it to select from DBA_ROLE_PRIVS and DBA_USERS. Since the DBA role grants all system privileges WITH ADMIN OPTION, why is it necessary to grant...

    170519660 pointsBadges:
  • upgrade from 8i to 9i or 10g

    This question might be a bit early for some, but at the end of the year 8i on windows goes off support. We will be looking at upgrading soon after. I would also expect that 10.2 might be on the horizon at that point. One would hope that would be a stable release. I would be interested to hear if...

    Laura550 pointsBadges:
  • Oracle Internet Directory

    Has anybody successfully synchronized OID with a third-party LDAP?

    Dbgomi0 pointsBadges:
  • Oracle Collaboration Suite

    Is anyone using or planning to use OCS?

    Paulwb0 pointsBadges:
  • To SPFILE or Not To SPFILE

    Hi, What are your experiences using the SPFILE? Why would I want to use the SPFILE versus the old PFILE? Thanks! - D.

    Dw499990 pointsBadges:
  • hardware/software configuration for web site hosting

    Thanks to all for replying to my previous question. This question is of general nature. I'm planning on creating(hosting) a web site, at which the main contents will be questionnaires, polling and compiling the ratings. I know I will need the database behind the HTML front-end. I will design and...

    Paulina0 pointsBadges:
  • Oracle 10g ASM

    Can you create ASM instance without creating a database? If yes, how?

    Mwhpsrc0 pointsBadges:
  • Oracle Reports development & Oracle Conurrent Manager

    In developing using Oracle Reports, the report runs fine on the workstation through the developer tool, however when we port the .rfd to Unix and run through the Oracle Apps concurrent manager there are errors in formatting. The error messages generated are not always sufficient to determine which...

    Holtmeyer0 pointsBadges:
  • Problem with dblinks generated from Oracle Warehouse Builder

    Hi, I am using Oracle Warehouse Builder 9i to implement my data warehouse. Normally, it generates dblinks containing a TNS reference: create database link <hostname>@<connector> connect to <user> identified by <password> using '<hostname>'; But sometimes it generates...

    ActorJack0 pointsBadges:
  • Full Export on Win 2000

    I have spent most of my DBA life on HP/UX. I just recently installed an App on Win 2000 and was able to easily set up schema exports, but I can't get the full database export to work. I am running it as SYSTEM and made sure that SYSTEM has the DBA role as well as EXP_FULL_DATABASE. Has anyone else...

    Oconnra0 pointsBadges:
  • Encryption in the Database

    Has anyone encrypted data in their Oracle/DB2/SQLServer databases? Can you share you experiences?

    Dw499990 pointsBadges:
  • Oracle database not starting on server reboot

    Would anyone know why an Oracle 8i database running on Windows 2000 will not automatically start on a server reboot?

    Oradba130 pointsBadges:
  • nt/2000 oracle experience to install on linux

    Do you happen to know of any good resources to help a windows Oracle dba very quickly appreciate the linux environment for an install there. It would be great to have a resource that can explain the similar (or not so similar) constructs in a windows environment to that of a linux one. Thanks, Laura

    Laura550 pointsBadges:
  • upgrade to 10g

    Looking for some input about upgrading/migrating to 10g from 8i databases. I have successfully migrated to 9i from 8i and even 7 version databases, but have not had the opportunity to work with 10g. Thank you, tuple9i

    Tuple9i0 pointsBadges:
  • Oracle storage parameters – next extent size and max extents

    I am looking for a general rule for determining the optimal setting for next extent size and max extents for oracle tables in an existing database. Specifically, is there some sort of formula that helps approximate the best values? Up to now I have been using best guess based on the size of the...

    Guido770 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.

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