oracle knowledge points accumulated (20,110,925 ~)

2011-09-25  来源:本站原创  分类:Database  人气:58 

First, export and import database run>> cmd
[Export]:
exp username / password file = c: \ data.dmp grants = y
[Import]
imp username / password file = d: \ data.dmp full = y ignore = y commit = y

Second, create a table space and authorization (by SqlDev to create user and authorization)
1, create a table space
CREATE TABLESPACE misspace DATAFILE 'D: \ oracle10g \ product \ 10.1.0 \ oradata \ orcl \ misspace.DBF' SIZE 200M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT MANUAL FLASHBACK ON;

2, CREATE USER sx_urms IDENTIFIED BY "password"
DEFAULT TABLESPACE misspace
TEMPORARY TABLESPACE "TEMP"
PROFILE DEFAULT
QUOTA UNLIMITED ON misspace;

3, authorization
GRANT UNDER ANY TABLE TO sx_urms WITH ADMIN OPTION;
GRANT UNDER ANY TYPE TO sx_urms WITH ADMIN OPTION;
GRANT UNDER ANY VIEW TO sx_urms WITH ADMIN OPTION;

GRANT "DBA" TO sx_urms WITH ADMIN OPTION;

相关文章
  • oracle knowledge points accumulated (20,110,925 ~) 2011-09-25

    First, export and import database run>> cmd [Export]: exp username / password file = c: \ data.dmp grants = y [Import] imp username / password file = d: \ data.dmp full = y ignore = y commit = y Second, create a table space and authorization (by Sql

  • oracle knowledge points 2011-01-06

    --oracle Basic knowledge points 1. oracle The physical database file types a. dbf (database file) Database data files b. log (logging file) Log File Log file records a certain period of time all the changes to the database operations ( Add, delete ,

  • Tetris written in javascript (with grade points accumulated) 2009-04-23

    <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gbk" /> <title> Tetris with grade points accumulated </ title> <style> # board tr td ( width: 20px; height: 20px; background-

  • javascript write Tetris (optional grade points accumulated) 2008-05-24

    <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gbk" /> <title> Tetris optional grade points accumulated </ title> <style> # board tr td ( width: 20px; height: 20px; backgro

  • Javajava knowledge points summary (1) 2010-06-16

    ● Use with label (label) of the break and continue instead of goto, so break out of the loop directly to a location outside, continue the cycle jump outside the current cycle from a label named to the role of circulating, reference label in the progr

  • Java synchronization. Asynchronous knowledge points 2010-07-25

    1, Keyword: thread (thread), thread-safe (thread safety), intercurrent (concurrent) synchronized (synchronous), asynchronized (asynchronous) volatile (volatile), atomic (atomic), share (sharing) 2, Summary Background: A reading and writing shared doc

  • After the company's written a little sort of knowledge points 2010-09-26

    At noon yesterday, was a company first despised, then there are two companies at the time the written conflict, and finally think about the, or whatever the X company (who face contempt to be a big risk), the results also appeared in the middle point

  • Written after the company that sort of knowledge points 2010-09-26

    The first is at noon yesterday by a company despised, and then written at the time there is conflict in the two companies, and finally think about the, or go to the X Company (risk being despised to be a big risk), the results also appeared in the mi

  • HTTP protocol knowledge points (collection) 2011-01-12

    Quote HTTP protocol knowledge points (collection) (A) object update check by: HTTP authentication in two ways whether the updates if-non-match, or if-modified-since. By Request is included in the header to the server-initiated inquiry. When the respo

  • C language knowledge points Supplements 2011-05-25

    /** * C Supplements knowledge of the language points with each test function of knowledge points * 1.C Language is actually an array in assembly language directly addressing the table, there are two access methods * int iArray[10]; * iArray[0]=1;// T

  • Microsoft internal patch (unofficial) of the method for obtaining (20,110,713) 2011-08-06

    http://support.microsoft.com/?kbid = kb behind the digital input can get this patch in ms and immediately requested information within the patch download. Examples are as follows: http://support.microsoft.com/?kbid=954232 * Press the upper left corne

  • oracle scattered collection of knowledge points 2010-07-21

    1. Query field contains '_' entry, because the _ in the like statement would have expressed any of the characters, where special treatment is necessary: -- Query the employee ID contains _ Data SELECT * FROM emp_t WHERE emp_id LIKE '%/_%'ESCAPE'/' 2.

  • senior oracle application of high-wage knowledge points to be aware of 2010-09-04

    SELECT empno, ename, sal, CASE deptno WHEN 10 THEN ' Finance Department ' WHEN 20 THEN ' R & D ' WHEN 30 THEN ' Sales ' ELSE ' Unknown sector ' END Departments from scott.emp; SELECT empno, ename, sal, DECODE(deptno, 10, ' Finance Department ', 20,'

  • Oracle temporary table space of learning knowledge points 2011-08-17

    Temporary tablespace For the large number sorting create temporary tablespace tbstemp datafile '$ORACLE_HOME/oradata/tbstmp01.dbf' size 50M Size 5M extent management local uniform size 1m; View temporary table space select * from v$tempfile f,v$table

  • Project Management Knowledge Points 2010-02-11

    1. Your team to use source code management tool Why? Should be used. VSS, CVS, PVCS, ClearCase, CCC / Harvest, FireFly can. My choice is VSS. 2. Your team using the defect management system put into effect? Should be used. ClearQuest is too complicat

  • Latest Oracle Technology Salon (3.20) 2011-03-16

    PSC dedicated special round table Chen Weixing - Oracle Performance Tuning Oracle WDP Certification Center Beijing Information Technology Co., Ltd. Senao Background technology: Learn how database performance by adjusting the way to maximize the use o

  • I have programming experience accumulated 20 2010-11-16

    Editor's Note: Danny may be the original author Jonathan (Jonathan Danylko) is a freelance web architects and programmers, has more than 20 years of programming experience, get involved in the field of e-commerce, biotechnology, real estate, medical,

  • [To] my programming experience accumulated 20 2010-11-25

    http://www.williamlong.info/archives/2405.html Editor's Note: Danny may be the original author Jonathan (Jonathan Danylko) is a freelance web architects and programmers, has more than 20 years of programming experience, get involved in the field of e

  • I accumulated 20 programming experience - references 2011-01-26

    Reference Note: the original from http://www.iteye.com/news/18570, for the convenience of my reading, the text format is slightly adjusted. Editor's Note: Danny may be the original author Jonathan (Jonathan Danylko) is a freelance web architect and p

  • Java will learn the knowledge points 2010-08-23

    java basics A common package, common classes, interfaces, packages: java.lang / java.awt / java.io / java.sql Category: BufferedReader / BufferedWriter / FileReader / FileWriter / String / Integer Interface: Remote List Map Document Node List Class: