标签归档文章: oracle

查询所有用户默认的tablespace以及tablespace指向的datafile

1。 查询所有用户默认的tablespace以及tablespace指向的datafile

select a1.username ,a1.default_tablespace , a2.file_name from dba_users a1, dba_data_files a2 where a1.default_tablespace = a2.tablespace_name;
更多…

Oracle instant client 安装

instant client 是连接oracle官方提供的数据库的客户端,非常小. 下载地址:

官方的介绍的步骤,虽然准确,但是过于简单.
Installation Steps:

1. Download the appropriate Instant Client packages for your platform. All installations REQUIRE the Basic package.

2. Unzip the packages into a single directory such as “instantclient”.
3. Set the library loading path in your environment to the directory in Step 2 (“instantclient”). On many UNIX platforms, LD_LIBRARY_PATH is the appropriate environment variable. On Windows, PATH should be used.

4. Start your application and enjoy.
更多…