oracle timestamp（6） 对应mysql什么类型？
请教大家一个问题，关于数据库移植方面的内容。oracle到mysql移植在oracle中存在timestamp（6）类型，可以保存6位秒信息。那么在mysql有什么类型可...
请教大家一个问题，关于数据库移植方面的内容。oracle到mysql移植 在oracle中存在timestamp（6）类型，可以保存6位秒信息。 那么在mysql有什么类型可以替换timestamp（6）呢？谢谢大家！
展开
2个回答
展开全部
1.管理员身份连接数据库
C:\Users\Administrator>sqlplus sys/sys@prjdb as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 17 23:50:55 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
2.查看当前归档模式，是归档还是非归档
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 228
Current log sequence 230
3.关闭数据库
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
C:\Users\Administrator>sqlplus sys/sys@prjdb as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jun 17 23:50:55 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
2.查看当前归档模式，是归档还是非归档
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 228
Current log sequence 230
3.关闭数据库
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
