When creating the first prototype within the database (backup)

2011-01-11  来源:本站原创  分类:Database  人气:54 

Internal database created when the first prototype. (Follow-up to a Comment, Index, database optimization, etc.)

select * from ADMIN.USER_INFO;

select * from all_tables where TABLE_NAME like '%USER%';
------------------create user------------------------
create user admin identified by admin
default tablespace users
Temporary TABLESPACE temp;

grant connect,resource,dba to ADMIN;

-------------------delete user------------------------
DROP USER ADMIN;

------------------create table-------------------------------
create table ADMIN.USER_INFO(
        USER_ID VARCHAR2(8) not null primary key,
        USER_NM VARCHAR2(40),
        LOGIN_ID VARCHAR2(20),
        USER_TYP VARCHAR2(2),
        PWD VARCHAR2(128),
        PWD_UPD_DY VARCHAR2(8),
        TEL_NO VARCHAR2(14),
        MOB_NO VARCHAR2(14),
        EMAIL_ID VARCHAR2(50),
        USE_FR_DY VARCHAR2(8),
        USE_TO_DY VARCHAR2(8),
        REGR_ID VARCHAR2(8),
        REG_DT DATE,
        UPDR_ID VARCHAR2(8),
        UPD_DT DATE);
------------------insert comment--------------------------
comment on table USER_INFO is '';

------------------task table--------------------------
create table ADMIN.TAST(
        PGM_NO VARCHAR2(9) not null primary key,
        PGM_NM VARCHAR2(100),
        SOR_NO VARCHAR2(15),
        BUSINES_FG VARCHAR2(2),
        BUSINES_AREA VARCHAR2(2),
        RESPON_KOR VARCHAR2(8),
        ACPT_DY VARCHAR2(8),
        END_DY VARCHAR2(8),
        CHN_END_DY VARCHAR2(8),
        GIVEN_DY VARCHAR2(8),
        DEVR_ID VARCHAR2(8),
        PGM_STS VARCHAR2(2),
        DIFFIC_LEVEL VARCHAR2(1),
        USE_TIME VARCHAR2(8),
        UPD_CNTS VARCHAR2(3000),
        REQRMNT_PATH VARCHAR2(100),
        UPD_PGM_PATH VARCHAR2(300),
        REGR_ID VARCHAR2(8),
        REG_DT DATE,
        UPDR_ID VARCHAR2(8),
        UPD_DT DATE);

-------------------test table----------------------
create table ADMIN.TEST(
        TEST_NO VARCHAR2(9) not null primary key,
        PGM_NO VARCHAR2(9) not null,
        PGM_NM VARCHAR2(100),
        SOR_NO VARCHAR2(15),
        BUSINES_FG VARCHAR2(2),
        BUSINES_AREA VARCHAR2(2),
        DEVR_ID VARCHAR2(8),
        TESTR_ID VARCHAR2(8),
        TEST_YM VARCHAR2(6),
        LAST_TEST_DY VARCHAR2(8),
        CHN_END_DY VARCHAR2(8),
        DEV_TYP VARCHAR2(2),
        DIFFIC_LEVEL VARCHAR2(1),
        UPD_CNTS VARCHAR2(3000),
        BUG_LIST VARCHAR2(3000),
        BUG_TOTAL_CNT NUMBER,
        RETURN_CNT NUMBER,
        NOT_NOTE_CNT NUMBER,
        VERSION_COMP_YN VARCHAR2(1),
        BUG_LEVEL_CNT1 NUMBER,
        BUG_LEVEL_CNT2 NUMBER,
        BUG_LEVEL_CNT3 NUMBER,
        TEST_REMARK VARCHAR2(3000),
        REGR_ID VARCHAR2(8),
        REG_DT DATE,
        UPDR_ID VARCHAR2(8),
        UPD_DT DATE);

-------------------prob table--------------------
create table ADMIN.PROB(
        PROB_NO VARCHAR2(9) not null primary key,
        PGM_NO VARCHAR(9) not null,
        PGM_NM VARCHAR2(100),
        SOR_NO VARCHAR2(15),
        BUSINES_FG VARCHAR2(2),
        BUSINES_AREA VARCHAR2(2),
        PROB_STS VARCHAR2(2),
        PROB_TITLE VARCHAR2(300),
        PROB_CNTS VARCHAR2(3000),
        PROB_CAUSE VARCHAR2(3000),
        ANSWER_CNTS VARCHAR2(3000),
        REGR_ID VARCHAR2(8),
        REG_DT DATE,
        UPDR_ID VARCHAR2(8),
        UPD_DT DATE);        

--------------------------------------------
相关文章
  • When creating the first prototype within the database (backup) 2011-01-11

    Internal database created when the first prototype. (Follow-up to a Comment, Index, database optimization, etc.) select * from ADMIN.USER_INFO; select * from all_tables where TABLE_NAME like '%USER%'; ------------------create user--------------------

  • Oracle Database Backup and Recovery Summary -exp/imp (Export and Import Bank and unloading equipment library) 2010-04-20

    sqlldr userid = B / A @ D control = result.ctl log = resulthis.out rows = 10000 bindsize = 8192000 1.1 Basic commands 1. Get Help $ Exp help = y $ Imp help = y 2. 3 kinds of work (1) Interactive $ Exp / / and then press the prompt for the required pa

  • Database backup and restore processing 2011-07-16

    Using T-SQL statements, implementing database backup and restore features in SQL Server reflects the knowledge of the four points: 1. Get SQL Server default directory on the server 2. Backup using SQL statements 3. Restore the use of SQL statements,

  • c # oracle database backup code 2011-03-07

    view plaincopy to clipboardprint? 01./// <summary> 02. /// Database backup 03. /// </summary> 04. /// <param name="fileName">dmp File name </param> 05. /// <param name="logFileName">log File name </para

  • Database Backup Summary 2010-03-31

    Database backup on many projects are often involved, especially on small personal office software used to. I own the project used database backup made a summary of the detailed steps please see From the "Database Backup own summary. Doc" file.

  • Using Ant to import and export database backup 2010-03-18

    <?xml version="1.0" encoding="GBK"?> <project name="TestAntOracle" default="updatedb" basedir="."> <!-- The configuration backup file is stored in the current path --> <property name=&

  • rails mysql database backup 2010-02-02

    In # (RAILS_ROOT) / lib / tasks established under db.rake, the mccxj to copy the code into, then press Alt + Shift + R bring up the dialog box is running Rake tasks, click "Refresh Tasks" button, the list will come out "db: backup: create&q

  • MySQL commonly used database backup and restore commands 2010-03-03

    MySQL database backup command mysqldump-hhostname-uusername-ppassword databasename> backupfile.sql Backup MySQL database table with the format <br /> delete backup deleted MySQL database table with the format, allowing the backup coverage without

  • Database Backup and Recovery (3) 2010-03-04

    The steps according to the book, step by step test, since there is a reference. Backup of a global database offline backup ---- a log with SYSDBA database (sql * plus); b View the location of data files; select name from v$datafile; c View the locati

  • Raiders complete Oracle Database Backup and Recovery 2010-03-09

    Raiders complete Oracle Database Backup and Recovery 1, Export / Import (Export / Import) Export can use data from the database, extracted, can be extracted using Import data sent back to Oracle Database to. 1, simply export the data (Export) and imp

  • Oracle database backup (hot. Cold. Exp) and recovery 2010-03-13

    Oracle Database Backup and Recovery ---- When we use a database, always want the contents of the database is reliable and correct, but because of computer system failures (including machine failure, media failure, misuse, etc.), the database may some

  • Sql Server 2000 database backup file to restore 2010-03-17

    SQL Server 2000 database backup file to restore 1, open Sql server 2000 database, right on the label in the database, select - "All Tasks -" Restore Database 2, pop-up dialog box to restore database (1) in the "General" tab "to re

  • oralce Database Backup and Restore 2010-03-30

    1, database backup operation, type cmd in the Start into the dos command window, Then enter the appropriate backup command can be, Command: exp username / password @ global database name file = 'file path + file name' owner = (user name) For example:

  • MySQL database backup and restore of the commonly used commands 2010-04-06

    MySQL database backup command mysqldump-hhostname-uusername-ppassword databasename> backupfile.sql Backup MySQL database table with the format <br /> delete backup deleted MySQL database table with the format, allowing the backup coverage without

  • MySQL database backup batch command BAT 2010-04-08

    This carried over http://www.jb51.net/article/19296.htm MySQL data backup tools may have a lot in this I'm going to share with you through the DOS batch commands and MySQL, WinRAR command to back up the work. Work environment Windows Server 2003, MyS

  • Oracle database backup command Exp / Imp (change) 2010-04-13

    ORACLE database has two types of backup methods. The first category is the Wuli backup, the method Databases for a complete recovery, but the database must run in return block mode (Ye Wu database in non-return block mode), and requires a lot of exte

  • DB2 database backup and recovery methods 2010-05-07

    Transfer from http://blog.sina.com.cn/s/blog_5cecbc550100bc55.html DB2 database backup methods and classification Database backup on the database in accordance with the use of influence to divide: Online backup (also known as hot backup or online bac

  • Use ssh command to restore mysql database backup 2010-05-08

    Login shell, you can also manage access to mysql database server mysql database directly. mysql-u username-ppassword-h hostname databasename Note: The above username that the user name, password means your password, hostname refers to the server host

  • SQL database backup maintenance 2010-05-10

    A: In the Enterprise Manager to operate SQL Server2000 is installed on the server, open the Start menu ---> programs ----> MicroSoft SQL Server - à in the Enterprise Manager to open Enterprise Manager, the console in turn points to open the root dir

  • Oracle Database Backup (exp / imp command) 2010-06-21

    -------------------------------------------------- ------------------------------------- Oracle Database Backup -------------------------------------------------- ------------------------------------- ORACLE database logical backup is divided into th