Now we are going to refresh SH schema.
Steps for schema refresh – before exporting
- Spool the output of roles and privileges assigned to the user .use the query below to view the role s and privileges and spool the out as .sql file.
SELECT object_type,count(*) from dba_objects where owner=’SHTEST’ group by object_type;
Verify total no of objects from above query. - write a dynamic query as below to generate privillege granting sql
select ‘grant ‘ || privilege ||’ to sh;’ from session_privs;
select ‘grant ‘ || role ||’ to sh;’ from session_roles; - query the default tablespace and size
select tablespace_name,sum(bytes/1024/1024) from dba_segments where owner=’SH’ group by tablespace_name; - Export the ‘sh’ schema
exp ‘usernmae/password file=’/location/sh_bkp.dmp’ log=’/location/sh_exp.log’ owner=’SH’ direct=y - Create the SH schema with the default tablespace and allocate quota on that tablespace on target database.
- Now run the roles and privileges spooled scripts.
- Connect the SH and verify the tablespace, roles and privileges then start importing
- Importing The ‘SH’ schema
imp ‘username/password’ file=’/location/sh_bkp.dmp’ log=’/location/sh_imp.log’ Fromuser=’SH’ touser=’SH’
SQL> SELECT object_type,count(*) from dba_objects where owner=’SHTEST’ group by object_type; - Compiling and analyzing SH Schema
exec dbms_utility.compile_schema(‘SH’);
exec dbms_utility.analyze_schema(‘SH’,'ESTIMATE’,ESTIMATE_PERCENT=>20);
参考至:http://vinu3012dba.blogspot.com/2010/10/schema-refresh-in-oracle-9i.html
如有错误,欢迎指正
邮箱:czmcj@163.com
相关推荐
refresh(); // 刷新当前页面信息 } /** * * @return Returns the currentPage. * */ public int getCurrentPage() { return currentPage; } /** * * @param currentPage * current page *...
pull_to_refresh_notification 语言:| 小部件以构建拉动以刷新效果。 样品4个糖果 样品5糖果 用代码刷新 刷新指标模式 enum RefreshIndicatorMode { drag, // Pointer is down. armed, // Dragged far enough ...
Android UI开发第二十一篇——下拉刷新列表实现(pull to refresh) http://blog.csdn.net/xyz_lmn/article/details/8101360
// 使用navigate().refresh()方法刷新页面 driver.navigate().refresh(); //使用navigate.to方法打开第二个页面:免费课 driver.navigate().to("https://www.imooc.com/course/list"); //使用navigate.back方法转...
jwt鉴权单独模块的微服务,良好的扩展性,代码规范注解齐全功能丰富。 可通过yaml自定义jwt过期时间、jwt签发机构、作者以及加密次数、盐值等操作。 基于spring.factories实现的SPI...refreshToken() // 刷新Token内容
在自己的程序中解决其他程序非法关闭后,托盘残留的死亡图标。一句话搞定:引入该dll文件RefreshSystemTray.RefreshSysTray.SysTray.Refresh();//消除死亡托盘图标
Refresh Groups 968 Resource Consumer Groups 970 Resource Plans 972 Roles 974 Rollback Segments 975 Sequences 977 Synonyms 978 System Privileges 980 Tables 981 Tablespaces 996 Triggers 1002 Types 1004 ...
快速SG Fast-SG是一种无需对齐的算法,可通过短读或长读来构建超快脚手架图。 目录 帮助和其他选项 NA12878的混合动力总成 执照 引文 编译说明 ... wget https://github.com/refresh-bio/KMC/releases/
获取refresh_token 注意 web端获取的refresh_token暂时无法分享 可以通过手机端查找日志获取refresh_token /sdcard/Android/data/com.alicloud.databox/files/logs/trace/userId/yunpan/latest.log 配置refresh_...
stm32单片机+oled屏实现贪吃蛇游戏软件源码,可供学习设计参考。 main() { ... GUI_Refresh(map);//刷新地图 if(GameOver()) { OLED_Clear(); OLED_ShowPicture(0,0,128,8,BMP); } } }
对于需要在特定时间轻松执行自动网页刷新的任何用户,Auto Refresh Plus都非常方便。它还提供内容检测支持,当您需要查找动态网页中包含的内容时,这确实非常有用。
一步解决其他程序非法关闭之后残留的托盘图标: RefreshSystemTray.RefreshSysTray.SysTray.Refresh();//消除死亡托盘图标 期望大家顶起!~
SpringSecurity-JWT-VERSION2(AccessToken和RefreshToken) version1太复杂,无法优化。accessToken refreshToken流安全登录处理流程详细说明转到博客文章JWT异常处理安全异常处理(AuthenticationEntryPoint,...
APP使用token和refreshToken实现接口身份认证,保持登录状态
Refresh 下拉刷新+上拉加载更多 ,仿淘宝的样子。有兴趣的可以研究下
Chrome自动刷新插件:Auto Refresh是一款可以自行在Chrome中定制刷新时间的谷歌浏览器插件,用户只需要简单的设置就可以让Chrome完成有用但无聊的定时重复刷新的操作。 Auto Refresh的使用方式也是非常的简单,可以...
EXP_FULL_DATABASE, IMP_FULL_DATABASE这两个角色用于数据导入导出工具的使用。 自定义角色 Oracle建议我们自定义自己的角色,使我们更加灵活方便去管理用户 创建角色 SQL> create role admin; 授权给...
.Refresh();//刷新 .GoBack();//后退 .GoForward();//前进 .Navigate(new Uri(address)); //打开链接 .Dock = DockStyle.Fill; //完全停靠在父容器中 .ScriptErrorsSuppressed ...
来源: 使用提取程序克隆Froom的原始源fetcher --url=https://github.com/pmmmwh/react-refresh-webpack-plugin/tree/main/examples/create-react-app 或者gitf ...提示:安装提取程序: npm install -g github-files-...
下拉刷新框架:android-Ultra-Pull-To-Refresh 导入AS教程:http://blog.csdn.net/jljcslg/article/details/50543548