--1, Plsql or navicat database client Tools Administrator account: Table space Create tablespace demo_tablespace logging datafile ' D:\Oracle\database\
tablespace\demo.dbf ' size 100M autoextend on next 100M maxsize 500M extent management local; --2, create user and authorize create user Demo_usename identified by demo_pwd DEFAULT tablespace demo_tablespace Temporary Temp
; Grant Create session to demo_usename;--This ensures that the user can log on to the database grant CREATE table to demo_usename;--so that the user can create a table grant connect to DEM
O_usename;
Grant Exp_full_database to Demo_usename;
Grant Imp_full_database to Demo_usename;
Grant resource to Demo_usename;
Grant CREATE procedure to Demo_usename;
Grant create trigger to Demo_usename;
Grant execute any procedure to demo_usename;
Grant Grant any privilege to demo_usename;
Grant restricted session to Demo_usename;
Grant Select any table to Demo_usename;
Grant unlimited tablespace to Demo_usename;
Grant create any view to Demo_usename; --3, create a recovery directory-(path needs to be built in advance, note: Linux needs to use:/) Create directory Vbmcarddump as ' D:\Oracle\databasE\dump '; Grant read, write on directory vbmcarddump to public;