Æí¸®ÇÑ È£½ºÆà ¹Ì¼ÒIDC

   
 
 
 

      1Â÷ ³×ÀÓ¼­¹ö :
      ns1.misoidc.com
      101.79.73.101

      2Â÷ ³×ÀÓ¼­¹ö :
      ns2.misoidc.com
      101.79.73.105

      ¾îÁ¦ : 211 ,¿À´Ã : 295
      Àüü : 1,151,037


     

 

 
ÀÛ¼ºÀÏ : 11-11-02 17:53
¿À¶óŬ °èÁ¤»ý¼º
 ±Û¾´ÀÌ : ½ÑÀ¥È£½ºÆÃ
Á¶È¸ : 27,484  

<¿À¶óŬ °èÁ¤»ý¼º>

1. ¿À¶óŬÀ» Á¢¼ÓÇÑ´Ù. °èÁ¤Àº ¾Æ¹«°Å³ª Á¢¼ÓÇصµ ¹«°üÇÔ.

(cmdâ¿¡¼­ ¹Ù·Î Á¢¼Ó½Ã C:\>sqlpluse "/as sysdba" ,

¸®´ª½º´Â ·çÆ®±ÇÇÑÀ¸·Î ·Î±×ÀÎÈÄ su - oracle Á¢¼ÓÇÏ¿© sqlplus "/as sysdba")

2. Á¢¼ÓÈÄ sys°èÁ¤À¸·Î Á¢¼ÓÀ» º¯°æÇÕ´Ï´Ù.

sql>conn /as sysdba

3. Å×ÀÌºí ½ºÆäÀ̽º »ý¼º

sql>create tablespace tester_sp

datafile '/home/oracle/tester_sp.dbf' size 50M

autoextend on next 1M maxsize 100M;

create tablespace Å×ÀÌºí½ºÆäÀ̽º¸í datafile 'ÀúÀå°æ·Î' size 50M

autoextend on next 1M maxsize 100M;

¡Ø ±âÁ¸ ¹é¾÷ µðºñ º¹±¸½Ã¿¡´Â Å×ÀÌºí½ºÆäÀ̽º »çÀÌÁ º¹±¸ÇÏ°íÀÚ ÇÏ´Â ÆÄÀÏÀÇ »çÀÌÁî Å©±â¿Í µ¿ÀÏÇϰųª Å©°Ô ÇØÁà¾ßµÈ´Ù.

4. Àӽà Å×ÀÌºí ½ºÆäÀ̽º »ý¼º

sql>create temporary tablespace tester_sp_temp

tempfile '/home/oracle/tester_sp_temp.dbf' size 20M;

create temporary tablespace Àӽà Å×ÀÌºí½ºÆäÀ̽º ¸í

tempfile 'ÀúÀå°æ·Î' size 100M;

5. sys°èÁ¤ Á¢¼®ÈÄ À¯Àú°èÁ¤»ý¼º ÇÕ´Ï´Ù.

sql>create user test identified by test default tablespace tester_sp temporary tablespace tester_sp_temp;

create user À¯ÀúÀ̸§ identified by ¾ÏÈ£ default tablespace »ý¼ºÇÑ Å×ÀÌºí ½ºÆäÀ̽º À̸§

temporary tablespace »ý¼ºÇÑ ÀÓ½ÃÅ×ÀÌºí ½ºÆäÀ̽º À̸§;

<»ý¼ºÇÑ°èÁ¤ ±ÇÇѺο©>

sql>grant connect, resource to test;

grant connect, resource to À¯ÀúÀ̸§;

<°èÁ¤»èÁ¦>

sql>drop user test cascade;

drop user À¯ÀúÀ̸§ cascade;

<Å×ÀÌºí½ºÆäÀ̽º »èÁ¦>

sql>drop tablespace tester_sp;

drop tablespace Å×ÀÌºí½ºÆäÀ̽º¸í;

Å×ÀÌºí½ºÆäÀ̽º¿¡ µ¥ÀÌŸ°¡ Á¸ÀçÇÏ´Â °æ¿ì including contentsÀ» Ãß°¡ÇØÁÜ.

ex) drop tablespace tester_sp including contents;

<DB ¹é¾÷Ç®±â>

c:\>imp test/123 file=c:\test.dmp

¶Ç´Â

c:\>imp userid=test/123@orc file=c:\test.dmp fromuser=test touser=test ignore=yes

imp °èÁ¤À̸§/°èÁ¤¾ÏÈ£ file=ÆÄÀÏÀ̸§.dmp

¿É¼Ç

imp userid=°èÁ¤À̸§/°èÁ¤¾ÏÈ£@sid¸í(@sid¸íÀº Á¦°ÅÇصµµÊ)

file=°æ·Î¹×ÆÄÀÏÀ̸§ fromuser=exp½Ã À¯Àú¾ÆÀ̵ð touser=imp¹ÞÀ» À¯Àú¾ÆÀ̵ð ignore=yes

<DB ¹é¾÷(dmp)>

c:\>exp test/123 file=c:\test.dmp

¶Ç´Â

c:\>exp userid=test/123@orc file=c:\test.dmp log=c:\test.log

exp °èÁ¤À̸§/°èÁ¤¾ÏÈ£ file=ÆÄÀÏÀ̸§.dmp

¶Ç´Â

exp userid=°èÁ¤À̸§/°èÁ¤¾ÏÈ£@sid¸í(@sid¸íÀº Á¦°ÅÇصµµÊ) file=°æ·Î¹×ÆÄÀÏÀ̸§ log=·Î±×°¡ÀúÀåµÉ ÆÄÀÏ



 
 

Total 78
¹øÈ£ Á¦   ¸ñ ±Û¾´ÀÌ ³¯Â¥ Á¶È¸
48 odbc connection string ½ÑÀ¥È£½ºÆà 04-04 23242
47 [MS-SQL]SQL Server 2005 ¿¬°á¿À·ù Áø´Ü¹æ¹ý ½ÑÀ¥È£½ºÆà 04-04 42764
46 ¸®´ª½º¿ë ¹é½Å - f-prot ¼³Ä¡ ¹× »ç¿ë¹ý ½ÑÀ¥È£½ºÆà 05-24 48647
45 Force10 OS Æß¿þ¾î ¾÷±×·¹ÀÌµå ½ÑÀ¥È£½ºÆà 06-28 34742
44 vsftp ¿¡¼­ »óÀ§ Æú´õ À̵¿ ¸·±â ½ÑÀ¥È£½ºÆà 07-19 20065
43 ¹é¾÷ ½´ÆÛºí·° È®ÀÎÇϱ⠽ÑÀ¥È£½ºÆà 07-21 18768
42 centos¿¡ oracle 11gR2 ¼³Ä¡ ½ÑÀ¥È£½ºÆà 09-21 81248
41 Oracle - sqlplus ·Î Á¢¼ÓÇϱâ, °èÁ¤»ý¼º, Å×À̺í»ý¼º ½ÑÀ¥È£½ºÆà 09-22 112180
40 ¾ÆÆÄÄ¡ À¥¼­¹ö ¹«·ÂÈ­½Ãų ½É°¢ÇÑ DoS °áÇÔ ¹ß°ß ½ÑÀ¥È£½ºÆà 10-20 26853
39 ¿À¶óŬ °èÁ¤»ý¼º ½ÑÀ¥È£½ºÆà 11-02 27485
38 ¿î¿µÀÚ°³ÀÎÀÚ·á ½ÑÀ¥È£½ºÆà 11-06 6
37 Install Tomcat 7 on CentOS, RHEL, or Fedora ½ÑÀ¥È£½ºÆà 11-15 56263
36 [CentOS] Tomcat 7.0.4 ¼³Ä¡ (¼öÁ¤1) ½ÑÀ¥È£½ºÆà 11-16 32797
35 ¾ÆÆÄÄ¡1 ÅèĹ5 ½ÑÀ¥È£½ºÆà 11-16 49474
34 mod_jk¸¦ ÀÌ¿ëÇÑ Apache2 + Tomcat5.5 ¿¬µ¿ ¹× °¡»óÈ£½ºÆà ½ÑÀ¥È£½ºÆà 11-17 29684
 1  2  3  4  5  6