oracleÊý¾Ý»¹ÔÎÊÌ⣬ϣÍû¸ßÊÖ¸øÓë´ð°¸
ÓÐÒ»¸ödmpÎļþ£¬
ÎÒÒ²ÊÇÏÖÔÚsqlplusÖÐÖ´ÐÐÒÔϲ½Öè
// 1.´´½¨±í¿Õ¼ä
create tablespace shanxi
datafile 'D:\shanxi.dbf'
size 20480M
extent management local
segment space management auto
online;
// 2.´´½¨±íÓû§
create user Óû§Ãû identified by ÃÜÂë
default tablespace shanxi
temporary tablespace temp
quota unlimited on shanxi;
// 3.ÊÚȨ
grant dba to Óû§Ãû;
// 4.Áª½Ó
conn Óû§Ãû
// ´ò¿ªÃüÁî´°¿Ú£¬ÊäÈëcmd
// Çл»µ½Êý¾Ý±íËùÔÚĿ¼
E:\>imp hao/hao fromuser=dbmiddata touser=hao ignore=y file=e:\dbbase2008.dmp
Import: Release 10.2.0.3.0 - Production on ÐÇÆÚ¶þ 12ÔÂ 8 00:02:58 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Á¬½Óµ½: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
¾Óɳ£¹æÂ·¾¶ÓÉ EXPORT:V09.02.00 ´´½¨µÄµ¼³öÎļþ
¾¯¸æ: ÕâЩ¶ÔÏóÓÉ DBMIDDATA µ¼³ö, ¶ø²»Êǵ±Ç°Óû§
ÒѾÍê³É ZHS16GBK ×Ö·û¼¯ºÍ AL16UTF16 NCHAR ×Ö·û¼¯Öеĵ¼Èë
µ¼³ö·þÎñÆ÷ʹÓà UTF8 NCHAR ×Ö·û¼¯ (¿ÉÄÜµÄ ncharset ת»»)
³É¹¦ÖÕÖ¹µ¼È룬µ«Ã»Óо¯¸æ
ÕâÊÇΪʲô£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
imp usename/password@netservicename file=e:\dbbase2008.dmp fromuser=´ÓÊý¾Ý¿âµ¼³
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
лл
ÎÒÒ²ÊÇÏëÖªµÀ
me too
ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ
Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ.......
¸öÈ˾õµÃÔÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½Ì ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
score±í
scoreid course studentid score
1 Êýѧ 2 99
2 Êýѧ 3 60
3 Êýѧ 4 80
4 ÓïÎÄ 5 79
5 ÓïÎÄ 6 58
6 ÓïÎÄ 1 66
7 Ó¢Óï 6 76
8 Ó¢Óï 4 87
9 Ó¢Óï 3 100
10Ó¢Óï 2 69
ÔõÑùµÃµ½Ã»ÃÅ¿ÎÖзÖÊý×î¸ßµÄÄÇ ......