Tag Info

New answers tagged

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.


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, ...


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

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 ...


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. ...


-1

http://bugs.mysql.com/bug.php?id=66609 MySQL workbench does not support "Migration from Oracle DBs is not supported: http://dev.mysql.com/doc/workbench/en/wb-migration-database-concepts.html"


0

Two things: 1) Are the Oracle binaries identical between the two databases? That message typically appears when you go from, say 11.0 to 11.2 binaries, and the catalog needs updated. The platforms need to be the same as well (Linux/Windows don't mix). 2) If you are trying to clone a database that is open, and you don't have archived logs, you will fail ...


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 ...


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 ...


0

Sounds like a job for a database trigger. Assuming the StartDate and EndDate are static (the values remain the same for a particular row always), a trigger would be fairly simple. If the EndDate could be updated after the row is created, it could still be done but would be more involved. This would handle where just one additional row would need to be ...


0

According to the Oracle documentation for the SELECT ... SAMPLE clause, the sample is random; it is just a coincidence that you are always getting the same rows on the local machine. You could try adding the SEED(x) clause, where x is a number from 0 to 4294967295; but that may not help going across a database link. select * from myTable@myDbLink ...



Top 50 recent answers are included