https://blog.youkuaiyun.com/gh57897053zh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/gh57897053/article/details/70255093https://blog.youkuaiyun.com/gh57897053/article/details/70255093gh57897053Thu, 20 Apr 2017 09:49:11 +0800https://blog.youkuaiyun.com/gh57897053/article/details/60761785https://blog.youkuaiyun.com/gh57897053/article/details/60761785gh57897053Tue, 07 Mar 2017 13:21:34 +0800https://blog.youkuaiyun.com/gh57897053/article/details/5778856https://blog.youkuaiyun.com/gh57897053/article/details/5778856gh57897053Sat, 31 Jul 2010 17:20:00 +08001.expdp和impdp
expdp
假设sglaw用户的默认表空间是users，导出用户sglaw所有数据：
SQL> conn / as sysdba
SQL> create directory dir as '/home/oracle/';
SQL> grant read,write on directory dir to system;
$expdp system/oracle directory=dir dumpfile=s]]>https://blog.youkuaiyun.com/gh57897053/article/details/5778836https://blog.youkuaiyun.com/gh57897053/article/details/5778836gh57897053Sat, 31 Jul 2010 17:07:00 +0800exp和imp时常由于oracle的版本问题出现各种异常。
这里有个原则就是：
imp版本必须>=exp版本。
1.在使用exp命令时，如果数据库是9i，而使用10g的client进行exp，会出现ora-06550错误（即客户端版本问题）。未有解决办法，还是使用9i的exp进行导出。
 
2.在使用imp时，如果目标数据库的版本高于oracle clinet的imp版本，则在导入后，出现“准备启动约束条件”卡死。
 
3.建]]>https://blog.youkuaiyun.com/gh57897053/article/details/4498154https://blog.youkuaiyun.com/gh57897053/article/details/4498154gh57897053Sat, 29 Aug 2009 22:33:00 +0800https://blog.youkuaiyun.com/gh57897053/article/details/4449551https://blog.youkuaiyun.com/gh57897053/article/details/4449551gh57897053Sat, 15 Aug 2009 15:09:00 +0800https://blog.youkuaiyun.com/gh57897053/article/details/4449510https://blog.youkuaiyun.com/gh57897053/article/details/4449510gh57897053Sat, 15 Aug 2009 14:56:00 +0800https://blog.youkuaiyun.com/gh57897053/article/details/4449486https://blog.youkuaiyun.com/gh57897053/article/details/4449486gh57897053Sat, 15 Aug 2009 14:52:00 +0800https://blog.youkuaiyun.com/gh57897053/article/details/4449468https://blog.youkuaiyun.com/gh57897053/article/details/4449468gh57897053Sat, 15 Aug 2009 14:43:00 +0800https://blog.youkuaiyun.com/gh57897053/article/details/4448496https://blog.youkuaiyun.com/gh57897053/article/details/4448496gh57897053Sat, 15 Aug 2009 07:22:00 +0800https://blog.youkuaiyun.com/gh57897053/article/details/4399977https://blog.youkuaiyun.com/gh57897053/article/details/4399977gh57897053Sat, 01 Aug 2009 16:15:00 +0800https://blog.youkuaiyun.com/gh57897053/article/details/4135463https://blog.youkuaiyun.com/gh57897053/article/details/4135463gh57897053Wed, 29 Apr 2009 10:08:00 +0800https://blog.youkuaiyun.com/gh57897053/article/details/4134605https://blog.youkuaiyun.com/gh57897053/article/details/4134605gh57897053Tue, 28 Apr 2009 22:27:00 +0800https://blog.youkuaiyun.com/gh57897053/article/details/4122459https://blog.youkuaiyun.com/gh57897053/article/details/4122459gh57897053Sat, 25 Apr 2009 14:02:00 +0800https://blog.youkuaiyun.com/gh57897053/article/details/4105615https://blog.youkuaiyun.com/gh57897053/article/details/4105615gh57897053Fri, 24 Apr 2009 08:45:00 +0800https://blog.youkuaiyun.com/gh57897053/article/details/4099456https://blog.youkuaiyun.com/gh57897053/article/details/4099456gh57897053Wed, 22 Apr 2009 09:36:00 +0800https://blog.youkuaiyun.com/gh57897053/article/details/4098388https://blog.youkuaiyun.com/gh57897053/article/details/4098388gh57897053Tue, 21 Apr 2009 18:14:00 +0800> Premiun Feature >> List 查看购买的高级功能。2、选择主菜单 Storage SubSystem >> Set Controller Clocks.. 完成存储系统的时间同步3、选择存储设备。4、选择DISK，作RAID，再划分L]]>https://blog.youkuaiyun.com/gh57897053/article/details/4091988https://blog.youkuaiyun.com/gh57897053/article/details/4091988gh57897053Sun, 19 Apr 2009 15:17:00 +0800https://blog.youkuaiyun.com/gh57897053/article/details/4089765https://blog.youkuaiyun.com/gh57897053/article/details/4089765gh57897053Sat, 18 Apr 2009 14:41:00 +0800https://blog.youkuaiyun.com/gh57897053/article/details/4086968https://blog.youkuaiyun.com/gh57897053/article/details/4086968gh57897053Fri, 17 Apr 2009 13:15:00 +0800