Tag Info

Hot answers tagged

3

Whether the data can be manipulated by a user depends on the rights he has. Rights to database objects like tables and views are given either directly to a user or via a role. Roles have the advantage that you can assign them to new users easily without having to deal with the details. I would suggest at least two roles: An admin role and a user role. ...


2

The answer You're in a transaction already. You can't really be outside of a transaction anyway. is not true. By default, an Oracle transaction starts at the first DML (insert/update/delete), and ends with commit/rollback. You can start a transaction manually, with the SET TRANSACTION command, but most people don't. As for a clearer answer between PG ...


2

The public link below gives an overview of the four installation type options for the 11gR2 client: http://docs.oracle.com/cd/E11882_01/install.112/e24322/install_overview.htm#LACLI1245 Instant Client: Enables you to install only the shared libraries required by Oracle Call Interface (OCI), Oracle C++ Call Interface (OCCI), Pro*C, or Java database ...


1

The lazy answer: You can use the Segment Advisor recomendations. Can be viewed in OEM, DBA_ADVISOR_RECOMMENDATIONS, o DBMS_SPACE.ASA_RECOMMENDATIONS procedure. https://docs.oracle.com/cd/E18283_01/server.112/e17120/schema003.htm You can also build your own script gathering data, joining, and do calcs from several storage related dictionary views, but, ...


1

Do both servers have similar hardware and OS? Is there enough storage space for the 11g database? Have you thought about using data pump instead? With data pump and enterprise edition you can export and import in parallel as well as compress. With 10g you can compress the meta data but not the data. With 11g you can compress the data and meta data. How does ...


1

It could be that one of the imp default parameters for Oracle 10G is different in Oracle 11G. I would try adding the buffer=4096000 parameter to the imp command to see if that helps. That parameter is available on both exp and imp commands.


1

It would be difficult to say whether this solution would be preferred without knowing more about the nature of the data you are storing and how it will be accessed, but here is another idea you may not have considered. Since your data is fairly static and will be accessed from PL/SQL and the application, you could simply embed the data in a PL/SQL package. ...


1

You should create a table and grant the appropriate permissions so that only the intended users have update capabilities. I strongly discourage using views in the manner you suggested. Since you are creating a table of states you don't need an ID value since each state is unique. The state or abbreviation could be the primary key. If you must use an ID ...


1

There are several ways to do this. One would be to use a pipelined function to return the additional row when the day spanning condition is detected. Another way is to duplicate the rows and then eliminate the ones that don't need to be duplicated and adjust the times for those that do. Here is an example: SELECT Case When TwoRowsNeeded = 1 And ...


1

@mbonaci sqlplus / as sysdba then issue command startup; to start the database Also on Linux with this error, you can check first if Oracle background processes are up with ps aux | grep pmon. Pmon is process monitor, or check some other background process. If they are not running then the database is not running.



Only top voted, non community-wiki answers of a minimum length are eligible