Oracle

Method 1: Is the server operating system windows? If yes, find "configuration and migration tools, administration assistant for Windows NT (AAW)", find the leaf node of your Oracle Home directory in the AAW tree, right click, select properties. In

1. Back up the entire directory of D: \ oracle (it is estimated that there are not so many, but to ensure security, copy the directory admin and oradata. another one is ora92 \ database. if this is not copied, the error 01991 may occur ); 2.

-- Create a tablespaceCreate tablespace tablename datafile 'e: \ oracle \ dbname. dbf' size 1024 M autoextend on next 100 m maxsize unlimited;Create smallfile temporary tablespace temptest tempfile 'e: \ oracle \ dbname2.dbf' size 100 m extent

The following methods can be used to determine the number of Oracle digits: 1. You can see through sqlplus Login A.64-bit logon is displayed $ Sqlplus "/As sysdba" SQL * Plus: Release 9.2.0.4.0-production on Wed Nov 16 15:27:28 2005

In start-run, enter the command sqlplus/nolog.Open sqlplus.exeThe following steps:SQL> connect sys/user password as sysdbaSQL> shutdown normalSQL> startup Mount The Oracle routine has been started. total system global area 293601280 bytes

1. Disable all foreign key constraints Run the following statement in PL/SQL developer: Select 'alter table' | table_name | 'Disable constraint' | constraint_name | ';' from user_constraints where constraint_type = 'R '; Copy the query

Http://luobeng.blogbus.com/logs/36329526.html 1. view the table space Select tablespace_name, to_char (sum (bytes)/(1024*1024), '999g999d999') cnt_mbFrom dba_extentsWhere owner = '& owner' and segment_name =' & table_name 'and segment_type

(1) oracleservicesid Database Service, which automatically starts and stops the database. If a database is installed, its default start type is automatic. The service process is Oracle. EXE, the parameter file initsid. ora, the log file sidalrt. log,

Suddenly one day, good system error: ORA-01722 Invalid Number Environment: oracle9 + JDBC access to the database. It was okay before. This error was suddenly found. Later referred to: http://davidyu720.itpub.net/post/31716/291191 to know the

Many users ask how to choose entry books and learn about Oracle's good books. Shao. First, I declare that this article only involves foreign works, because there are very few domestic works, most of which are pieced together. Speaking of

Upgrade nbear to v2.1.0. Major updates are as follows: 1) added Oracle and MySQL db providers so that nbear currently supports Oracle and My SQL databases; 2) fix the command cache issue in lukiya when calling the same stored procedure with

Because the previous server end CodeThese are all stored procedures used (Oracle or MSSQLServer ). Now we are working on supporting desktop applications (ACCESS ). Because the table structure is the same, you just want to take the previous Code and

Problem description: unable to locate required client software. For more information about specific requirements for synchronizing with this connected data source, see the synchronization service help. Microsoft Forefront Identity Manager (FIM)

I recently studied Oracle 10g. Let's start with the installation. During the installation, the default port 1521 has beenProgramAfter oracle is installed, the port is changed to 1522. So I changed the port to 1521 again. At that time, I could

Time Function instance: Select sysdate, add_months (sysdate, 12) from dual; -- add 1 yearSelect sysdate, add_months (sysdate, 1) from dual; -- add JanuarySelect sysdate, to_char (sysdate + 7, 'yyyy-mm-dd hh24: MI: ss') from dual; -- add 1

Private void download (string ID){String filename = page. Request. physicalapplicationpath + "systemmanage \ sysfile \" + datetime. Now. tostring ("yyyymmddhhmmss") + ". Zip ";Oracleconnection conn = NULL;String connstring = system. configuration.

There are many date functions in Oracle, such: 1. add_months () is used to increase or decrease the number of months from a date value. Date_value: = add_months (date_value, number_of_months) Example: SQL> select add_months (sysdate, 12) "next year"

Type refcursortype is ref cursor; -- cursor type definition, used to return a dataset /*************************************** *************************** Function Description: Common paging stored procedures for large data volumes* Created by:

Http://timnity.javaeye.com/blog/280383  Since last week, a problem occurred in the Oracle database on the server. In less than half a day, the maxsession (150) problem will be reported. It must be because the maximum number of database sessions

/* Source: Network Collect and organize: ChenJ Created at: 13: 21 Modification time: */ /* Symptom: ORA-28001: the password has expired Cause: In Oracle11g, "PASSWORD_LIFE_TIME = 180 days" is set in the default profile by default. Impact: After the