Oracle数据库相关操作记录
程序员文章站
2022-05-11 07:53:49
Oracle数据库相关操作导入dmp部分表表空间自增导入dmp部分表imp nguser/root@orcl file=D:\aaaa.dmp log=C:\Users\hhh\Desktop\aaaa.log fromuser=nguser TABLES=(t_table1,t_table2),buffer=10000000 statistics=none touser=nguser,ignore=Y;表空间自增select tablespace_name,file_name,autoex...
导入dmp部分表
imp nguser/root@orcl file=D:\aaaa.dmp log=C:\Users\hhh\Desktop\aaaa.log fromuser=nguser TABLES=(t_table1,t_table2),buffer=10000000 statistics=none touser=nguser,ignore=Y;
表空间自增
-
select tablespace_name,file_name,autoextensible from dba_data_files;
-
ALTER TABLESPACE USERS ADD DATAFILE ‘E:\APP\ADMINISTRATOR\ORADATA\NGTEST\USERS03.DBF’ SIZE 4096M;
-
alter database datafile ‘E:\APP\ADMINISTRATOR\ORADATA\NGTEST\USERS03.DBF’ autoextend on;
本文地址：https://blog.csdn.net/weixin_46410916/article/details/108995933