Oracle ʹÓñí×ܽá
/*============´´½¨Customer±í==========*/
create table Customer
(
Customer_id number(6) not null,
Customer_name varchar2(50) not null,
Password varchar2(20) not null,
True_name varchar2(20),
Email_address varchar2(50) not null, --Ψһ
Password_question varchar2(50) not null,
Password_anwser varchar2(50) not null,
Status char(1), --ĬÈÏÊÇ1£¬È¡Öµ0»ò1
Customer_level char(1), --ĬÈÏÊÇ1£¬È¡Öµ1£¬2£¬3
Score number(6),
Register_date date, --ĬÈÏΪϵͳʱ¼ä
Login_time timestamp,
Login_count number(6),
Login_ip char(6)
);
/*===========´´½¨Orders±í==========*/
create table Orders
(
Order_id varchar2(10) not null,
Order_Customer_id number(6) not null,
Order_date date not null,
Order_price number not null
);
/*==========²é
Ïà¹ØÎĵµ£º
ÔÁ´½Ó£ºhttp://www.oracle.com/webapps/dialogue/dlgpage.jsp?p_ext=Y&p_dlg_id=7731619&src=6817982&Act=4&sckw=APACMK09050910MPP005.GCM.8074.110
ÄÜ·ñÔÚµÚһʱ¼ä
»ñµÃÐÂÕ½ÂԵķ´À¡Òâ¼û£¿
ÄÜ·ñͨ¹ý¹ÜÀíÄ£ÐÍ
À´Ô¤²âÒµÎñÊý¾Ý£¿
......
LinuxÏÂÆô¶¯oracle10gµÄemºÍisqlplusµÄ·½·¨:
×¢:$ORACLE_HOMEΪoracleµÄ°²×°Â·¾¶
1,ʹÓÃEM(enterprise managment)
1.1Æô¶¯EM
$ORACLE_HOME/bin/emctl start dbconsole
Èç¹û³öÏÖÏÂÃæÏà¹ØÐÅÏ¢,˵Ã÷·þÎñÆô¶¯
Z set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.1.0.3.0
Copyright (c) 1996, 200 ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......