how to create database service in oracle 11g

Oracle Database 11g Release 2 installation On CentOS 6.6 (x64 platform), centosx64Oracle Database 11g Release 2 installation On CentOS 6.6 (x64 platform)(Note: the current user is "tdtc100 ")1. down install files(1) linux.x64_11gR2_database_1of2.zip(2) linux.x64_11gr2_databa

Tags: WinForm style blog http tar extBecause like new things, so basically computer development tools are the latest, Oracle also installed 11g R2, but colleague classmate is not 11g R1 is 10G, from here I exported the DMP file in their direction in, all show:IMP-00010: Not a valid export file, header validation failedFor this problem has been distressed, almost

Issue: ORACLE 11g exports a user's own table with the EXP command export and IMP imports 10g found empty table cannot be exportedCause: 11g When you start to build a table, segment is not assigned by default to save space, and when the table inserts the first data, it is redistributed segmentWorkaround 3 ways:1: Insert a piece of data into the blank, and then del

In many databases there is a data type called an automatic growth column. Almost all relational databases support the operation of automatic growth columns, but only Oracle is special, he only provides an automatic growth column after the Oracle 12C version, none of which has been done before, and all similar operations must be handled in a sequential fashion. a version prior to

BKJIA exclusive Translation] This article provides a general introduction to the automatic database maintenance task management in Oracle 11g. The article is concise for two reasons: 1. Most people have not touched these settings. Even so, if you are processing maintenance tasks at night and opening a maintenance window at night is not a good idea, you may want t

/spa_jzdb3 directory=back dumpfile=sqlset11_tab.dmp logfile=sqlset11_tab.log table_exists_action=replace EXEC Dbms_sqltune. Unpack_stgtab_sqlset (sqlset_name=> ' spa_sqlset ', sqlset_owner=> ' SPA ', Replace=>true, STAGING_TABLE_NAME= > ' Sqlset11_tab ', staging_schema_owner=> ' SPA '); Decompression stage table Sqlset11_tab to Sqlset4 Create a spa task, Sir, into the trail of 10g and then in 11g in the ge

The computer is WIN10 64 bit, the database is Oracle 11g, log in today　　When displayed: Ora-01031:insufficient privileges, insufficient permissions.Referring to this method, my local Users and groups have ORA_DBA groups, and the group also has a system login user, and the database is also installed to use for a period

Oracle 11g remote export database 1. Create a TNS string: zqxt = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 132.97.172.186)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ora11g) )) 2. query the tablespace SQL of remote data: 1 ), select distinct 'select dbms_metadata.get_

Solve the problem that the database cannot automatically collect statistics due to Oracle 11g installation. Recently, it was found that some Oracle 11g databases could not automatically collect statistics. Some View query results are as follows: SQL> select client_name, stat

Tags: blog login set LAN soft Enterprise Edition www. . exe getOracle website Download Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html Oracle Installation The download consists of two compressed packages: Win64_11gr2_database_1of2.zip,win64_11gr2_database_2of2.zip 2. Extract the two compressed packages to the same directory and click the "setup.exe" file

Tags: out get success ons ted Tput res char TNOStored procedures with no parameters sql> Create or replace procedure Get_time is2 begin3 Dbms_output.put_line (sysdate);4 End;5/ Procedure created. sql> exec get_time; 15-may-17 PL/SQL procedure successfully completed. Stored procedure with in parameter sql> Create or Replace procedure Add_dept2 (v_dept_id in number, v_dept_name in varchar2) is3 begin4 INSERT