《1-Oracle安装专题.pptVIP

1.4 Oracle基本的登录 Oracle数据库的两个管理员账户： system 系统对象（表、索引、存储过程、用户）的最高权限，可以控制管理所有对象。 sys 最高级别，除了所有system权限之外，可以控制数据库的物理结构（如：文件、运行模式）。 必须以 as sysdba 模式登录。 * * Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 1.4 Oracle基本的登录 登录企业管理器: 搜狗浏览器不好使 https://localhost:1158/em/ * * Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 1.4 Oracle基本的登录 system用户 * * Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 1.4 Oracle基本的登录 对于sys用户 * * Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 1.4 Oracle基本的登录 sqlplus 软件工具： 纯命令好工具 在 开始-程序-oracle-开发工具-sqlplus 或者在命令行界面输入sqlplus * * Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 1.4 Oracle基本的登录 在sqlplus中使用sys登录 再输入密码栏目，先输入密码然后输入 as sysdba * * Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd. 1.4 Oracle基本的登录 更加一般的登录方法 SqlPlus下的功能选项 执行 SqlPlus /nolog会直接进入sqlplus工具界面而先不用登录。 想要操作对应数据库，就要先执行connect 命令 * * Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile . Copyright 2004-2011 Aspose Pty Ltd.