1,向数据库中插入带‘’的字段
UPDATE "TSSA"."PUB_BUSITYPE_TD"
SET BUSIFORMLIST = ' <? xml version="1.0" encoding="GB2312" standalone="no" ?> < list type ='||chr(39)||'EOSENTITYDEF'||chr(39)||'></list>' WHERE BUSI_ID =336
SET BUSIFORMLIST = ' <? xml version="1.0" encoding="GB2312" standalone="no" ?> < list type ='||chr(39)||'EOSENTITYDEF'||chr(39)||'></list>' WHERE BUSI_ID =336
2,常用数据库备份
select * from v$tablespace;
sqlplus /nolog
connect /as sysdba
CREATE TABLESPACE "TSSAFAULT" LOGGING DATAFILE '/home/oracle/tablespace/TSSAFAULT.dbf' SIZE 100M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE "TSSAINDEX" LOGGING DATAFILE '/home/oracle/tablespace/TSSAINDEX.dbf' SIZE 50M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE "TSSAIOMS" LOGGING DATAFILE '/home/oracle/tablespace/TSSAIOMS.dbf' SIZE 100M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
CREATE TABLESPACE "TSSAPUB" LOGGING DATAFILE '/home/oracle/tablespace/TSSAPUB.dbf' SIZE 500M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
CREATE TABLESPACE "TSSAWF" LOGGING DATAFILE '/home/oracle/tablespace/TSSAWF.dbf' SIZE 300M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
create user tssa identified by tssa2006 default tablespace TSSAPUB temporary tablespace TEMP;
grant dba to tssa;
exit
[/home/oracle]:
imp userid=tssa/tssa2006 fromuser=tssa touser=tssa ignore=y file=/home/oracle/jxitsa.dmp
ps -ef |grep java
http://134.224.4.252:7006/eosmgr
-------------------------------------------------------------------------------------------
SQL> connect sys/sys123 as sysdba
Connected.
SQL> CREATE TABLESPACE "TSSAFAULT" LOGGING DATAFILE '/home/oracle/tablespace/TSSAFAULT.dbf' SIZE 100M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
3
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
[oracle@localhost ~]$ ls
admin doc install oradata p2617419_220_GENERIC.zip p4198954_21_LINUX.zip product
connect htliutssa.dmp OPatch p2617419_10102_GENERIC.zip p3238244_9204_LINUX.zip patch tablespace
[oracle@localhost ~]$ cd tablespace
[oracle@localhost tablespace]$ ls
[oracle@localhost tablespace]$ ls
[oracle@localhost tablespace]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Nov 16 10:17:08 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/sys123 as sysdba
Connected.
SQL> CREATE TABLESPACE "TSSAFAULT" LOGGING DATAFILE '/home/oracle/tablespace/TSSAFAULT.dbf' SIZE 100M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
3
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
[oracle@localhost tablespace]$ exit
logout
There are stopped jobs.
[oracle@localhost tablespace]$ cd ..
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Nov 16 10:19:04 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> sqlplus /nolog
SP2-0734: unknown command beginning "sqlplus /n..." - rest of line ignored.
SQL> connect sys/sys123 as sysdba
Connected.
SQL> CREATE TABLESPACE "TSSAFAULT" LOGGING DATAFILE '/home/oracle/tablespace/TSSAFAULT.dbf' SIZE 100M
REUSE
SQL> CREATE TABLESPACE "TSSAFAULT" LOGGING DATAFILE '/home/oracle/tablespace/TSSAFAULT.dbf' SIZE 100M
2 REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> EXIT
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
[oracle@localhost ~]$ LS
-bash: LS: command not found
[oracle@localhost ~]$ LS
-bash: LS: command not found
[oracle@localhost ~]$ LS
-bash: LS: command not found
[oracle@localhost ~]$ ls
admin doc install oradata p2617419_220_GENERIC.zip p4198954_21_LINUX.zip product
connect htliutssa.dmp OPatch p2617419_10102_GENERIC.zip p3238244_9204_LINUX.zip patch tablespace
[oracle@localhost ~]$ cd tablespace
[oracle@localhost tablespace]$ ls
TSSAFAULT.dbf
[oracle@localhost tablespace]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Nov 16 10:30:23 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/sys123 as sysdba
Connected.
SQL> CREATE TABLESPACE "TSSAINDEX" LOGGING DATAFILE '/home/oracle/tablespace/TSSAINDEX.dbf' SIZE 50M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
3
SQL> CREATE TABLESPACE "TSSAINDEX" LOGGING DATAFILE '/home/oracle/tablespace/TSSAINDEX.dbf' SIZE 50M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
3
SQL> CREATE TABLESPACE "TSSAINDEX" LOGGING DATAFILE '/home/oracle/tablespace/TSSAINDEX.dbf' SIZE 50M
2 REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> CREATE TABLESPACE "TSSAIOMS" LOGGING DATAFILE '/home/oracle/tablespace/TSSAIOMS.dbf' SIZE 100M
2 REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
Tablespace created.
SQL> CREATE TABLESPACE "TSSAPUB" LOGGING DATAFILE '/home/oracle/tablespace/TSSAPUB.dbf' SIZE 500M
2 REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
Tablespace created.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
[oracle@localhost tablespace]$ ls
TSSAFAULT.dbf TSSAINDEX.dbf TSSAIOMS.dbf TSSAPUB.dbf
[oracle@localhost tablespace]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Nov 16 10:36:02 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/sys123 as sysdba
Connected.
SQL> CREATE TABLESPACE "TSSAWF" LOGGING DATAFILE '/home/oracle/tablespace/TSSAWF.dbf' SIZE 300M
2 REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
Tablespace created.
SQL> create user tssa identified by tssa2006
default tablespace TSSAPUB
temporary
SQL> create user tssa identified by tssa2006 default tablespace TSSAPUB temporary tablespace TEMP;
User created.
SQL> grant dba to tssa;
Grant succeeded.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
[oracle@localhost tablespace]$ cd ..
[oracle@localhost ~]$ ls
admin doc install oradata p2617419_220_GENERIC.zip p4198954_21_LINUX.zip product
connect htliutssa.dmp OPatch p2617419_10102_GENERIC.zip p3238244_9204_LINUX.zip patch tablespace
[oracle@localhost ~]$ pwd
/home/oracle
[oracle@localhost ~]$ imp userid=tssa/tssa2006 fromuser=tssa touser=tssa ignore=y file=/home/oracle/htliutssa.dmp
Import: Release 9.2.0.4.0 - Production on Fri Nov 16 10:41:29 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses ZHS32GB18030 character set (possible charset conversion)
export server uses UTF8 NCHAR character set (possible ncharset conversion)
. . importing table "LINEITEM" 0 rows imported
. . importing table "LOGIN_USER" 2 rows imported
. . importing table "MUSIC" 7 rows imported
. . importing table "NET_SERVER_CONFIG" 3 rows imported
. . importing table "OFFI_INFO" 49 rows imported
. . importing table "ORDERS" 0 rows imported
. . importing table "PHS_SEND" 0 rows imported
. . importing table "PLAN_TABLE" 0 rows imported
. . importing table "PLAN_TYPE" 2 rows imported
[oracle@localhost ~]$ ls
admin doc install oradata p2617419_220_GENERIC.zip p4198954_21_LINUX.zip product
connect htliutssa.dmp OPatch p2617419_10102_GENERIC.zip p3238244_9204_LINUX.zip patch tablespace
[oracle@localhost ~]$
--------------------------------------------------------------------------------------
交谈中请勿轻信汇款、中奖消息,勿轻易拨打陌生电话。
我爱海 13:45:56
老大 我把山西数据重导一边 会不会和安徽有冲突?
简简单单 13:46:32
会,需要把安徽的数据全部清除.
我爱海 13:46:58
怎么全部清楚
简简单单 13:47:34
像上午一样两条命令进sqlplus
然后执行:
drop user tssa cascade;
等待N长时间.tssa用户带他的所有表就全部清除掉了.
简简单单 13:47:51
然后再执行:
create user tssa identified by tssa2006 default tablespace TSSAPUB temporary tablespace TEMP;
grant dba to tssa;
简简单单 13:48:02
上面是把tssa用户再建起来.
简简单单 13:48:11
最后再执行imp把数据导入即可.
简简单单 16:16:49
先执行shutdown immediate
简简单单 16:16:57
数据库关闭后,再执行startup
简简单单 16:17:03
然后再执行drop user....
我爱海 16:18:30
要不要启动 监听了
杀进程:
ps -ef |grep java
雨过天晴 (2007-10-29 09:14:25)
呵呵!!真晕!!
我爱海 (2007-10-29 09:14:12)
要重启 还不知道管理员密码
雨过天晴 (2007-10-29 09:09:04)
你是不是要重启啊!!你不会的话!把地址和用户名!发给我我帮你!你要学习的那话!照着那样就行了
我爱海 (2007-10-29 09:08:02)
你有没有搞过
雨过天晴 (2007-10-29 09:06:08)
数据库的启动:
在root下关数据库
1.#su - oracle //转到oracle用户
2.$lsnrctl stop //关监听
3.$shutdown immediate
//关数据库
/home/oracle/product/9.2/bin 在里面起服务!
./sqlplus /nolog
在root开数据库
1.#su - oracle //转到oracle用户
2.$sqlplus /onlog
3.$connect /as sysdba
4.$startup
切换到oracle用户下 //开数据库
$lsnrctl start //开监听
雨过天晴 (2007-09-17 13:55:28)
你那个英语王找没有找到注册玛啊!
我爱海 (2007-09-17 13:50:55)
妈的 真痛苦 我这边事真多
我爱海 (2007-09-14 15:31:22)
恩 那倒也是
雨过天晴 (2007-09-14 15:31:12)
呵呵!!明天先听他怎么说吧!!
[root@localhost ~]# useradd sxtsioms
sxtsioms123
解压:
tar -tf sxtsioms.tar
数据库乱码:
[root@localhost ~]# cd /etc/sysconfig
LANG="zh_CN.GB2312"
#LANG="en_US"
LANGUAGE="zh_CN.GB2312:zh_CN"
SUPPORTED="zh_CN.GB2312:zh_CN:zh"
SYSFONT="lat0-sun16"
SYSFONTACM="8859-15"
增加用户:
[root@localhost ~]# userdel jxprimeton
[root@localhost ~]# adduser jxprimeton
[root@localhost ~]# passwd jxprimeton
Changing password for user jxprimeton.
New UNIX password:
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
普元地址:
ftp://211.152.33.58/EOSV5.1.2/
导出数据库:
exp tssa/tssa2006@SXEOMS file=jxitsa.dmp
sqlplus /nolog
connect /as sysdba
CREATE TABLESPACE "TSSAFAULT" LOGGING DATAFILE '/home/oracle/tablespace/TSSAFAULT.dbf' SIZE 100M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE "TSSAINDEX" LOGGING DATAFILE '/home/oracle/tablespace/TSSAINDEX.dbf' SIZE 50M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE "TSSAIOMS" LOGGING DATAFILE '/home/oracle/tablespace/TSSAIOMS.dbf' SIZE 100M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
CREATE TABLESPACE "TSSAPUB" LOGGING DATAFILE '/home/oracle/tablespace/TSSAPUB.dbf' SIZE 500M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
CREATE TABLESPACE "TSSAWF" LOGGING DATAFILE '/home/oracle/tablespace/TSSAWF.dbf' SIZE 300M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
create user tssa identified by tssa2006 default tablespace TSSAPUB temporary tablespace TEMP;
grant dba to tssa;
exit
[/home/oracle]:
imp userid=tssa/tssa2006 fromuser=tssa touser=tssa ignore=y file=/home/oracle/jxitsa.dmp
ps -ef |grep java
http://134.224.4.252:7006/eosmgr
-------------------------------------------------------------------------------------------
SQL> connect sys/sys123 as sysdba
Connected.
SQL> CREATE TABLESPACE "TSSAFAULT" LOGGING DATAFILE '/home/oracle/tablespace/TSSAFAULT.dbf' SIZE 100M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
3
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
[oracle@localhost ~]$ ls
admin doc install oradata p2617419_220_GENERIC.zip p4198954_21_LINUX.zip product
connect htliutssa.dmp OPatch p2617419_10102_GENERIC.zip p3238244_9204_LINUX.zip patch tablespace
[oracle@localhost ~]$ cd tablespace
[oracle@localhost tablespace]$ ls
[oracle@localhost tablespace]$ ls
[oracle@localhost tablespace]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Nov 16 10:17:08 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/sys123 as sysdba
Connected.
SQL> CREATE TABLESPACE "TSSAFAULT" LOGGING DATAFILE '/home/oracle/tablespace/TSSAFAULT.dbf' SIZE 100M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
3
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
[oracle@localhost tablespace]$ exit
logout
There are stopped jobs.
[oracle@localhost tablespace]$ cd ..
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Nov 16 10:19:04 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> sqlplus /nolog
SP2-0734: unknown command beginning "sqlplus /n..." - rest of line ignored.
SQL> connect sys/sys123 as sysdba
Connected.
SQL> CREATE TABLESPACE "TSSAFAULT" LOGGING DATAFILE '/home/oracle/tablespace/TSSAFAULT.dbf' SIZE 100M
REUSE
SQL> CREATE TABLESPACE "TSSAFAULT" LOGGING DATAFILE '/home/oracle/tablespace/TSSAFAULT.dbf' SIZE 100M
2 REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> EXIT
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
[oracle@localhost ~]$ LS
-bash: LS: command not found
[oracle@localhost ~]$ LS
-bash: LS: command not found
[oracle@localhost ~]$ LS
-bash: LS: command not found
[oracle@localhost ~]$ ls
admin doc install oradata p2617419_220_GENERIC.zip p4198954_21_LINUX.zip product
connect htliutssa.dmp OPatch p2617419_10102_GENERIC.zip p3238244_9204_LINUX.zip patch tablespace
[oracle@localhost ~]$ cd tablespace
[oracle@localhost tablespace]$ ls
TSSAFAULT.dbf
[oracle@localhost tablespace]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Nov 16 10:30:23 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/sys123 as sysdba
Connected.
SQL> CREATE TABLESPACE "TSSAINDEX" LOGGING DATAFILE '/home/oracle/tablespace/TSSAINDEX.dbf' SIZE 50M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
3
SQL> CREATE TABLESPACE "TSSAINDEX" LOGGING DATAFILE '/home/oracle/tablespace/TSSAINDEX.dbf' SIZE 50M
REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
3
SQL> CREATE TABLESPACE "TSSAINDEX" LOGGING DATAFILE '/home/oracle/tablespace/TSSAINDEX.dbf' SIZE 50M
2 REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> CREATE TABLESPACE "TSSAIOMS" LOGGING DATAFILE '/home/oracle/tablespace/TSSAIOMS.dbf' SIZE 100M
2 REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
Tablespace created.
SQL> CREATE TABLESPACE "TSSAPUB" LOGGING DATAFILE '/home/oracle/tablespace/TSSAPUB.dbf' SIZE 500M
2 REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
Tablespace created.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
[oracle@localhost tablespace]$ ls
TSSAFAULT.dbf TSSAINDEX.dbf TSSAIOMS.dbf TSSAPUB.dbf
[oracle@localhost tablespace]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Nov 16 10:36:02 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/sys123 as sysdba
Connected.
SQL> CREATE TABLESPACE "TSSAWF" LOGGING DATAFILE '/home/oracle/tablespace/TSSAWF.dbf' SIZE 300M
2 REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;
Tablespace created.
SQL> create user tssa identified by tssa2006
default tablespace TSSAPUB
temporary
SQL> create user tssa identified by tssa2006 default tablespace TSSAPUB temporary tablespace TEMP;
User created.
SQL> grant dba to tssa;
Grant succeeded.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
[oracle@localhost tablespace]$ cd ..
[oracle@localhost ~]$ ls
admin doc install oradata p2617419_220_GENERIC.zip p4198954_21_LINUX.zip product
connect htliutssa.dmp OPatch p2617419_10102_GENERIC.zip p3238244_9204_LINUX.zip patch tablespace
[oracle@localhost ~]$ pwd
/home/oracle
[oracle@localhost ~]$ imp userid=tssa/tssa2006 fromuser=tssa touser=tssa ignore=y file=/home/oracle/htliutssa.dmp
Import: Release 9.2.0.4.0 - Production on Fri Nov 16 10:41:29 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses ZHS32GB18030 character set (possible charset conversion)
export server uses UTF8 NCHAR character set (possible ncharset conversion)
. . importing table "LINEITEM" 0 rows imported
. . importing table "LOGIN_USER" 2 rows imported
. . importing table "MUSIC" 7 rows imported
. . importing table "NET_SERVER_CONFIG" 3 rows imported
. . importing table "OFFI_INFO" 49 rows imported
. . importing table "ORDERS" 0 rows imported
. . importing table "PHS_SEND" 0 rows imported
. . importing table "PLAN_TABLE" 0 rows imported
. . importing table "PLAN_TYPE" 2 rows imported
[oracle@localhost ~]$ ls
admin doc install oradata p2617419_220_GENERIC.zip p4198954_21_LINUX.zip product
connect htliutssa.dmp OPatch p2617419_10102_GENERIC.zip p3238244_9204_LINUX.zip patch tablespace
[oracle@localhost ~]$
--------------------------------------------------------------------------------------
交谈中请勿轻信汇款、中奖消息,勿轻易拨打陌生电话。
我爱海 13:45:56
老大 我把山西数据重导一边 会不会和安徽有冲突?
简简单单 13:46:32
会,需要把安徽的数据全部清除.
我爱海 13:46:58
怎么全部清楚
简简单单 13:47:34
像上午一样两条命令进sqlplus
然后执行:
drop user tssa cascade;
等待N长时间.tssa用户带他的所有表就全部清除掉了.
简简单单 13:47:51
然后再执行:
create user tssa identified by tssa2006 default tablespace TSSAPUB temporary tablespace TEMP;
grant dba to tssa;
简简单单 13:48:02
上面是把tssa用户再建起来.
简简单单 13:48:11
最后再执行imp把数据导入即可.
简简单单 16:16:49
先执行shutdown immediate
简简单单 16:16:57
数据库关闭后,再执行startup
简简单单 16:17:03
然后再执行drop user....
我爱海 16:18:30
要不要启动 监听了
杀进程:
ps -ef |grep java
雨过天晴 (2007-10-29 09:14:25)
呵呵!!真晕!!
我爱海 (2007-10-29 09:14:12)
要重启 还不知道管理员密码
雨过天晴 (2007-10-29 09:09:04)
你是不是要重启啊!!你不会的话!把地址和用户名!发给我我帮你!你要学习的那话!照着那样就行了
我爱海 (2007-10-29 09:08:02)
你有没有搞过
雨过天晴 (2007-10-29 09:06:08)
数据库的启动:
在root下关数据库
1.#su - oracle //转到oracle用户
2.$lsnrctl stop //关监听
3.$shutdown immediate
//关数据库
/home/oracle/product/9.2/bin 在里面起服务!
./sqlplus /nolog
在root开数据库
1.#su - oracle //转到oracle用户
2.$sqlplus /onlog
3.$connect /as sysdba
4.$startup
切换到oracle用户下 //开数据库
$lsnrctl start //开监听
雨过天晴 (2007-09-17 13:55:28)
你那个英语王找没有找到注册玛啊!
我爱海 (2007-09-17 13:50:55)
妈的 真痛苦 我这边事真多
我爱海 (2007-09-14 15:31:22)
恩 那倒也是
雨过天晴 (2007-09-14 15:31:12)
呵呵!!明天先听他怎么说吧!!
[root@localhost ~]# useradd sxtsioms
sxtsioms123
解压:
tar -tf sxtsioms.tar
数据库乱码:
[root@localhost ~]# cd /etc/sysconfig
LANG="zh_CN.GB2312"
#LANG="en_US"
LANGUAGE="zh_CN.GB2312:zh_CN"
SUPPORTED="zh_CN.GB2312:zh_CN:zh"
SYSFONT="lat0-sun16"
SYSFONTACM="8859-15"
增加用户:
[root@localhost ~]# userdel jxprimeton
[root@localhost ~]# adduser jxprimeton
[root@localhost ~]# passwd jxprimeton
Changing password for user jxprimeton.
New UNIX password:
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
普元地址:
ftp://211.152.33.58/EOSV5.1.2/
导出数据库:
exp tssa/tssa2006@SXEOMS file=jxitsa.dmp