FAQ redirects

From Oracle FAQ

This is a work in progress. Help us to improve this page or provide feedback on the discussion page. Expect this article to change frequently.

We are busy removing FAQ's from the main site and adding them to the wiki. This article keeps record of the old deleted URL's so we can setup redirect later.

Contents 1 APEX FAQ 2 ASM FAQ 3 Data Guard FAQ 4 Gateways 5 HTTP Server FAQ 6 Exp/ imp FAQ 7 JDeveloper FAQ 8 Mod plsql FAQ 9 Newbies FAQ 10 Partitioning FAQ 11 PL/SQL FAQ 12 Portal FAQ 13 RAC FAQ 14 SQL FAQ 15 SQL*Loader FAQ 16 SQL*Plus FAQ 17 Web Cache FAQ 18 XMLDB FAQ

APEX FAQ

• http://www.orafaq.com/faq/can_one_print_information_to_the_screen_from_htmldb
• http://www.orafaq.com/faq/how_do_i_get_data_in_report_columns_to_wrap
• http://www.orafaq.com/faq/how_does_one_send_e_mail_from_htmldb

ASM FAQ

• http://www.orafaq.com/faq/asm
• http://www.orafaq.com/faq/how_many_disk_groups_should_i_have
• http://www.orafaq.com/faq/how_to_check_how_much_disk_space_is_allocated_in_use_by_an_asm_instance

Data Guard FAQ

• http://www.orafaq.com/faq/how_does_one_create_a_standby_database
• http://www.orafaq.com/faq/how_to_check_whether_standby_is_doing_recovery
• http://www.orafaq.com/faq/how_to_delay_the_applying_of_archived_logs_on_a_physical_standby_database

Gateways

Deleted:

• http://www.orafaq.com/faq/what_is_the_oracle_open_gateways
• http://www.orafaq.com/faq/what_transparent_gateways_are_available
• http://www.orafaq.com/faq/what_procedural_gateways_are_available
• http://www.orafaq.com/faq/what_access_managers_are_available
• http://www.orafaq.com/faq/what_replication_servers_are_available
• http://www.orafaq.com/faq/where_can_one_get_more_info_about_oracle_gateways

HTTP Server FAQ

• http://www.orafaq.com/faq/ohs
• http://www.orafaq.com/faq/how_does_one_start_and_stop_the_oracle_http_server
• http://www.orafaq.com/faq/what_is_the_oracle_http_server_and_how_does_it_work
• http://www.orafaq.com/faq/how_does_one_publish_static_html_pages_on_the_oracle_http_server
• http://www.orafaq.com/faq/how_does_one_execute_standard_cgi_bin_programs_from_the_oracle_http_server
• http://www.orafaq.com/faq/how_does_one_password_protect_certain_directories
• http://www.orafaq.com/faq/how_does_one_configure_the_oracle_http_server
• http://www.orafaq.com/faq/can_one_start_the_apache_listener_on_port_80
• http://www.orafaq.com/faq/how_does_oracle_extend_the_apache_web_server

Deleted:

• http://www.orafaq.com/faq/where_can_one_get_more_info_about_the_oracle_http_server

Exp/ imp FAQ

• http://www.orafaq.com/faq/server_utilities
• http://www.orafaq.com/faq/import_export
• http://www.orafaq.com/faq/what_is_import_export_and_why_does_one_need_it
• http://www.orafaq.com/faq/how_does_one_use_the_import_export_utilities
• http://www.orafaq.com/faq/can_one_export_a_subset_of_a_table
• http://www.orafaq.com/faq/can_one_monitor_how_fast_a_table_is_imported
• http://www.orafaq.com/faq/can_one_import_tables_to_a_different_tablespace
• http://www.orafaq.com/faq/does_one_need_to_drop_truncate_objects_before_importing
• http://www.orafaq.com/faq/can_one_import_export_between_different_versions_of_oracle
• http://www.orafaq.com/faq/can_one_export_to_multiple_files_can_one_beat_the_unix_2_gig_limit
• http://www.orafaq.com/faq/how_can_one_improve_import_export_performance
• http://www.orafaq.com/faq/what_are_the_common_import_export_problems

JDeveloper FAQ

• http://www.orafaq.com/faq/how_does_one_set_runtime_parameter_in_jdeveloper
• http://www.orafaq.com/faq/what_is_infobus_dac_and_what_is_it_used_for

Deleted:

• http://www.orafaq.com/faq/what_is_jdeveloper_and_what_is_it_used_for

Mod plsql FAQ

• http://www.orafaq.com/faq/mod_plsql
• http://www.orafaq.com/faq/how_does_one_start_and_stop_mod_plsql
• http://www.orafaq.com/faq/what_is_mod_plsql_and_what_can_one_use_it_for
• http://www.orafaq.com/faq/how_does_one_configure_mod_plsql
• http://www.orafaq.com/faq/how_does_one_program_using_mod_plsql
• http://www.orafaq.com/faq/how_does_one_use_http_cookies
• http://www.orafaq.com/faq/can_a_web_page_be_refreshed_reloaded_after_a_given_interval
• http://www.orafaq.com/faq/how_can_one_page_forward_and_backwards_through_a_table
• http://www.orafaq.com/faq/how_to_do_multi_user_updates_using_the_oracle_webserver
• http://www.orafaq.com/faq/can_one_use_designer_2000_to_generate_web_applications
• http://www.orafaq.com/faq/can_one_use_a_different_web_server_from_the_one_included_by_oracle
• http://www.orafaq.com/faq/should_one_access_oracle_via_the_cgi_interface_or_the_wrb
• http://www.orafaq.com/faq/we_want_to_do_some_more_advanced_authentication_what_are_my_options
• http://www.orafaq.com/faq/right_im_storing_userids_in_a_table_how_does_one_encrypt_the_passwords
• http://www.orafaq.com/faq/are_there_alternatives_to_keeping_authentication_information_in_the_configuration_file
• http://www.orafaq.com/faq/how_does_one_program_using_the_wrb_api
• http://www.orafaq.com/faq/ive_lost_the_web_server_administrators_password_what_can_one_do

Deleted:

• http://www.orafaq.com/faq/why_does_one_get_requested_url_was_not_found_on_this_server
• http://www.orafaq.com/faq/fixing_request_failed_we_were_unable_to_process_your_request_at_this_time_errors
• http://www.orafaq.com/faq/webserver_doesnt_notice_change_of_permissions_on_scripts_to_make_it_readable_and_executable
• http://www.orafaq.com/faq/where_can_one_get_more_info_about_mod_plsql

Newbies FAQ

• http://www.orafaq.com/faq/how_does_one_add_information_to_the_oracle_faq
• http://www.orafaq.com/faq/where_can_i_post_my_oracle_questions
• http://www.orafaq.com/faq/where_is_the_oracle_documentation
• http://www.orafaq.com/faq/where_can_i_get_oracle_software_for_free

Partitioning FAQ

• http://www.orafaq.com/faq/how_does_one_enable_partition_support_for_a_database

Deleted:

• http://www.orafaq.com/faq/what_is_oracle_partitioning

PL/SQL FAQ

• http://www.orafaq.com/faq/what_is_pl_sql_and_what_is_it_used_for
• http://www.orafaq.com/faq/how_can_one_see_if_somebody_modified_any_code
• http://www.orafaq.com/faq/should_one_use_pl_sql_or_java_to_code_procedures_and_triggers
• http://www.orafaq.com/faq/how_can_one_search_pl_sql_code_for_a_string_key_value
• http://www.orafaq.com/faq/how_can_one_keep_a_history_of_pl_sql_code_changes
• http://www.orafaq.com/faq/how_can_i_protect_my_pl_sql_source_code
• http://www.orafaq.com/faq/can_one_print_to_the_screen_from_pl_sql
• http://www.orafaq.com/faq/can_one_read_write_files_from_pl_sql
• http://www.orafaq.com/faq/can_one_call_ddl_statements_from_pl_sql
• http://www.orafaq.com/faq/can_one_use_dynamic_sql_statements_from_pl_sql
• http://www.orafaq.com/faq/what_is_the_difference_between_type_and_rowtype
• http://www.orafaq.com/faq/what_is_the_result_of_comparing_null_with_null
• http://www.orafaq.com/faq/how_does_one_get_the_value_of_a_sequence_into_a_pl_sql_variable
• http://www.orafaq.com/faq/can_one_execute_an_operating_system_command_from_pl_sql
• http://www.orafaq.com/faq/how_does_one_loop_through_tables_in_pl_sql
• http://www.orafaq.com/faq/how_often_should_one_commit_in_a_pl_sql_loop_what_is_the_best_commit_strategy
• http://www.orafaq.com/faq/i_can_select_from_sql_plus_but_not_from_pl_sql_what_is_wrong
• http://www.orafaq.com/faq/what_is_a_mutating_and_constraining_table
• http://www.orafaq.com/faq/can_one_pass_an_object_table_as_an_argument_to_a_remote_procedure
• http://www.orafaq.com/faq/what_is_the_difference_between_stored_procedures_and_functions
• http://www.orafaq.com/faq/is_there_a_pl_sql_engine_in_sql_plus
• http://www.orafaq.com/faq/is_there_a_limit_on_the_size_of_a_pl_sql_block
• http://www.orafaq.com/faq/can_one_commit_from_within_a_trigger

Deleted:

• http://www.orafaq.com/faq/where_can_one_find_more_info_about_pl_sql

Portal FAQ

• http://www.orafaq.com/faq/portal
• http://www.orafaq.com/faq/what_is_oracle_portal_webdb_and_what_is_it_used_for
• http://www.orafaq.com/faq/what_is_the_difference_between_a_portal_and_a_portlet
• http://www.orafaq.com/faq/what_is_oracle_portal_to_go_and_what_is_it_used_for
• http://www.orafaq.com/faq/how_does_one_create_a_new_portlet

Deleted:

• http://www.orafaq.com/faq/how_does_one_drop_a_webdb_site_from_a_database
• http://www.orafaq.com/faq/where_can_one_get_more_info_about_oracle_portal

RAC FAQ

• http://www.orafaq.com/faq/can_any_application_be_deployed_on_rac
• http://www.orafaq.com/faq/do_you_need_special_hardware_to_run_rac
• http://www.orafaq.com/faq/how_does_one_convert_a_single_instance_database_to_rac
• http://www.orafaq.com/faq/how_can_i_test_if_a_database_is_running_in_rac_mode
• http://www.orafaq.com/faq/what_is_pinging_and_why_is_it_so_bad
• http://www.orafaq.com/faq/how_can_i_keep_track_of_active_instances
• http://www.orafaq.com/faq/how_does_one_stop_and_start_rac_instances
• http://www.orafaq.com/faq/how_does_one_set_up_a_common_sql_net_connect_string_for_all_ops_instances

Deleted:

• http://www.orafaq.com/faq/what_is_rac_ops
• http://www.orafaq.com/faq/what_are_the_benefits_for_running_rac
• http://www.orafaq.com/faq/how_does_one_monitor_pcm_lock_activity
• http://www.orafaq.com/faq/how_many_pcm_locks_are_allocated_per_instance_file

SQL FAQ

• http://www.orafaq.com/faq/what_are_the_difference_between_ddl_dml_and_dcl_commands
• http://www.orafaq.com/faq/what_is_sql_and_where_does_it_come_from
• http://www.orafaq.com/faq/difference_between_truncate_delete_and_drop_commands
• http://www.orafaq.com/faq/how_does_one_escape_special_characters_when_writing_sql_queries
• http://www.orafaq.com/faq/can_one_select_a_random_collection_of_rows_from_a_table
• http://www.orafaq.com/faq/how_does_one_eliminate_duplicates_rows_from_a_table
• http://www.orafaq.com/faq/how_does_one_get_the_time_difference_between_two_date_columns
• http://www.orafaq.com/faq/how_does_one_add_a_day_hour_minute_second_to_a_date_value
• http://www.orafaq.com/faq/how_does_one_code_a_matrix_crosstab_pivot_report_in_sql
• http://www.orafaq.com/faq/can_one_retrieve_only_rows_x_to_y_from_a_table
• http://www.orafaq.com/faq/can_one_retrieve_only_the_nth_row_from_a_table
• http://www.orafaq.com/faq/how_can_one_dump_examine_the_exact_content_of_a_database_column
• http://www.orafaq.com/faq/how_does_one_add_a_column_to_the_middle_of_a_table
• http://www.orafaq.com/faq/how_does_one_code_a_tree_structured_query
• http://www.orafaq.com/faq/how_does_one_count_sum_data_values_in_a_column
• http://www.orafaq.com/faq/how_does_one_drop_rename_a_columns_in_a_table
• http://www.orafaq.com/faq/how_does_one_implement_if_then_else_logic_in_a_select_statement
• http://www.orafaq.com/faq/how_does_one_prevent_oracle_from_using_an_index
• http://www.orafaq.com/faq/how_does_one_select_every_nth_row_from_a_table
• http://www.orafaq.com/faq/how_does_one_select_the_last_n_rows_from_a_table
• http://www.orafaq.com/faq/how_does_one_select_the_top_n_rows_from_a_table
• http://www.orafaq.com/faq/how_to_generate_a_histograms_text_graphs_using_sql
• http://www.orafaq.com/faq/map_rows_to_a_column
• http://www.orafaq.com/faq/what_is_the_difference_between_varchar_varchar2_and_char_data_types

SQL*Loader FAQ

• http://www.orafaq.com/faq/sql_loader
• http://www.orafaq.com/faq/how_does_one_use_the_sql_loader_utility
• http://www.orafaq.com/faq/what_is_sql_loader_and_what_is_it_used_for
• http://www.orafaq.com/faq/how_does_one_load_ms_excel_data_into_oracle
• http://www.orafaq.com/faq/is_there_a_sql_unloader_to_download_data_to_a_flat_file
• http://www.orafaq.com/faq/can_one_load_variable_and_fix_length_data_records
• http://www.orafaq.com/faq/can_one_skip_header_records_load_while_loading
• http://www.orafaq.com/faq/can_one_modify_and_add_data_as_the_database_gets_loaded
• http://www.orafaq.com/faq/can_one_load_data_from_multiple_files_into_multiple_tables_at_once
• http://www.orafaq.com/faq/can_one_selectively_load_only_the_records_that_one_need
• http://www.orafaq.com/faq/can_one_skip_certain_columns_while_loading_data
• http://www.orafaq.com/faq/how_does_one_load_multi_line_records
• http://www.orafaq.com/faq/how_can_one_get_sql_loader_to_commit_only_at_the_end_of_the_load_file
• http://www.orafaq.com/faq/can_one_improve_the_performance_of_sql_loader
• http://www.orafaq.com/faq/what_is_the_difference_between_the_conventional_and_direct_path_loader
• http://www.orafaq.com/faq/how_does_one_use_sql_loader_to_load_images_sound_clips_and_documents
• http://www.orafaq.com/faq/how_does_one_load_ebcdic_data

SQL*Plus FAQ

• http://www.orafaq.com/faq/how_does_one_use_the_sql_plus_utility
• http://www.orafaq.com/faq/what_is_sql_plus_and_where_does_it_come_from
• http://www.orafaq.com/faq/what_commands_can_be_executed_from_sql_plus
• http://www.orafaq.com/faq/what_are_the_basic_sql_plus_commands
• http://www.orafaq.com/faq/what_is_afiedt_buf
• http://www.orafaq.com/faq/im_unable_to_edit_files_what_is_wrong
• http://www.orafaq.com/faq/how_does_one_enable_the_sql_plus_help_facility
• http://www.orafaq.com/faq/what_is_the_difference_between_and_help
• http://www.orafaq.com/faq/what_is_the_difference_between_and
• http://www.orafaq.com/faq/what_is_the_difference_between_and_0
• http://www.orafaq.com/faq/what_is_the_difference_between_and_host
• http://www.orafaq.com/faq/can_one_run_commands_when_sql_plus_starts_up
• http://www.orafaq.com/faq/can_one_set_the_sql_plus_command_prompt_to_something_more_useful
• http://www.orafaq.com/faq/how_does_one_disable_interactive_prompting_in_sql_plus
• http://www.orafaq.com/faq/how_does_one_trap_errors_in_sql_plus
• http://www.orafaq.com/faq/how_does_one_trace_and_explain_sql_statements_from_sql_plus
• http://www.orafaq.com/faq/how_can_one_prevent_sql_plus_connection_warning_messages
• http://www.orafaq.com/faq/can_one_prevent_users_from_executing_devious_commands
• http://www.orafaq.com/faq/how_does_one_restore_session_state_in_sql_plus
• http://www.orafaq.com/faq/how_does_one_disable_sql_plus_formatting
• http://www.orafaq.com/faq/can_one_pass_operating_system_parameters_to_sql_plus
• http://www.orafaq.com/faq/somethings_wrong_with_my_clob_nclob_long_column_where_is_my_data
• http://www.orafaq.com/faq/how_does_one_copy_data_from_one_database_to_another_in_sql_plus
• http://www.orafaq.com/faq/can_one_generate_html_reports_from_sql_plus

Deleted:

• http://www.orafaq.com/faq/where_can_one_get_more_info_about_sql_plus

Web Cache FAQ

• http://www.orafaq.com/faq/application_server
• http://www.orafaq.com/faq/web_cache
• http://www.orafaq.com/faq/what_is_the_oracle_web_cache
• http://www.orafaq.com/faq/what_is_the_difference_between_the_database_can_web_caches
• http://www.orafaq.com/faq/how_does_one_install_and_configure_the_web_cache
• http://www.orafaq.com/faq/how_does_one_stop_and_start_the_web_cache
• http://www.orafaq.com/faq/how_does_one_monitor_the_web_cache

Deleted:

• http://www.orafaq.com/faq/where_can_one_get_more_info_about_the_web_cache

XMLDB FAQ

• http://www.orafaq.com/faq/how_does_one_install_xmldb_into_a_database