Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    kerala
    Posts
    24

    Unanswered: i have doubts..pls help

    Can u give me the answers for these questions
    1)In Windows NT, what parameter specifies the actual location of the parameter file
    2)To ensure proper data conversion between databases with
    different character sets what all steps we should do


    regards
    praveenagri

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    (1) IFILE

    (2)

    Oracle will perform its own conversion depending on the source and target set. For proper conversion to take place, the target database character set must be a superset of the source database character set.

    run the csscan utility to check whether conversion is safe or problematic.

    You can also use length semantics instead of byte semantics in case of multibyte, variable length charactor set.

    For more information, please read the oracle documentation regarding globalization support (oracel 9i).

    HTH
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Also in the registry, you will find that location of the parameter file
    that Oracle will use to autostart on system startup...

    [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0\ORA_xxx_P FILE]

    xxx is the sid...

    HTH
    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •