Tag Info

Hot answers tagged

12

The free and open-source SchemaCrawler tool will do what you need. SchemaCrawler outputs details of your schema (tables, views, procedures, and more) in a diff-able plain-text format (text, CSV, or XHTML). SchemaCrawler can also output data (including CLOBs and BLOBs) in the same plain-text formats. You can use a standard diff program to diff the current ...


8

Set the system parameter ALTER SYSTEM SET remote_login_passwordfile = NONE SCOPE=SPFILE; Then restart the database.


7

It depends what you are trying to do but one short answer is: imp system/password@sid file=(filename) log=imp.log fromuser=(existing user) touser=(new user) The last 3 here: log, fromuser, touser are optional. You might give some more details about what you are doing if that doesn't help...


7

Sun Solaris, because: the system is rock solid and itself one of best it's been Oracle's primary and reference platform for a long time (and still is patched very early and well tested) it scales from a $200 PC to massive multiprocessor machines (think development, test and production each cost effective in almost the same environment) has best ...


7

The space used by a table is the space used by all its extents : SQL> SELECT SUM(bytes), SUM(bytes)/1024/1024 MB 2 FROM dba_extents 3 WHERE owner = :owner 4 AND segment_name = :table_name; SUM(BYTES) MB ---------- ---------- 3066429440 2924,375


7

Via OEM 10g, Connect to the database as usual Click on the Schema tab On the Tables link within Database Objects Enter the schema name and object name (optional) and click Go Use the radio button to select the table you want to look at and click on Edit (Don't click on the table name link) Click on the Segments tab (and wait...) You will see the size of ...


6

you don't need any of this stuff. otn.oracle.com Oracle has a free tool called SQL Developer. it has a schema diff.


6

I figured out that that you could pass that two params to your Java app to resolve the issue: -Duser.country=en -Duser.language=en You could configure the values at environment variable level as well (depends from your OS).


5

SELECT * FROM V$VERSION; More here: http://www.adp-gmbh.ch/ora/misc/dynamic_performance_views.html


4

You could use TOAD is a great generic tool for Oracle development. There is a trial version for testing. From the features list: Data Compare and Sync wizard Synchronize data across database platforms Another product you could test is OraPowerTools: OraPowerTools is a collection of native oracle database utilities. This ...


4

I don't think there's such a thing as the "best" OS for the purposes you're using Oracle for here. A sandbox and the number of users you have is relatively small scale stuff; this ain't a huge Fortune 500 deployment. I also get the feeling that "unbreakable" security - while always good to have - isn't as crucial a factor in this case as it would be in ...


4

Look into using the RMAN DUPLICATE command. I believe this was introduced in 9i, but is certainly available in 10g. It takes care of all of those steps that used to be necessary when cloning manually such as renaming datafiles, recreating control files, resetting database name, etc. If you have a new directory structure for data and log files you can just ...


4

It depends on the type of export (dump) that was done from the original database. Oracle does four types of exports (called modes): Full User Table(s) Tablespace(s) Assuming that a Full export was done, you'd do something like: SET ORACLE_SID=dbsid imp system/manager FULL=y FILE=database.dmp LOG=import.log STATISTICS=recalculate Having said that, you ...


4

Look into "Real Application Testing" It's an extra cost option for Oracle, but basically does exactly as you've described


4

In Oracle, as of version 11.2, you can't rename a schema (=user). See this discussion on AskTom for a workaround: you would export the user, reimport with the good name (using FROMUSER and TOUSER). All references (if any) in pl/sql code will have to be updated manually. Grants and public synonyms will have to be recreated separately.


3

Oracle 9i and above uses special UNDO tablespaces and REDO logs to manage its transactions. REDO stores a log of the statements executed, and UNDO stores before and after images of database blocks affected by those statements. Did a bit more digging... If you have access to Oracle Metalink (their support site) look up Bug ID 3418428 This seems to be your ...


3

They are (most likely) Archived Redo Logs. They could be needed if a recovery is required. They are not deleted by Oracle automatically. Normally, your backup process (like RMAN) will back these up from their default location and delete them. How is this database backed up? If you do not know, I would ask the vendor. This might be a sign that something ...


3

I'd go by Oracle's recomendations, and since Oracle really want's its own box then using Oracle Unbreakable Linux makes the most sense. If you need to scale above what a single AMD64 machine can handle then, and only then, would I consider some of the midrange Sun SPARC hardware.


3

You can uninstall the JVM if you don't need it. You can also set the java pool size to zero which should also accomplish what you want.


3

Your database is looping as it attempt to do a recovery and bring undo segments back online to recover your database. Since you are not a dba, I would immediately get oracle support on the line and tell them that you need major assistance and that you are not a dba. They will very likely have you startup the database and disable the recovery manager that ...


3

Install, Patch, and clone. Oh. And read the documentation too: "Oracle Software Cloning using Oracle Universal Installer" "Cloning an Oracle Home on Linux-x86" (exist for others O/S & hardware)


3

Do you have a backup of your database? Overwriting the SYSTEM tablespace data files would necessitate a complete restore from backup.


3

Are you sure that the original approach using the all_tables view includes LOB extents? I would think not. Here is one that I am finding useful: with da as ( SELECT owner, segment_name, SUM(bytes)/1024/1024 size_mb FROM dba_extents group by rollup(owner, segment_name) ) select owner, segment_name, size_mb, round(size_mb/total_mb*100) from da ...


3

Make a backup and restore it to your new Pc and make backups in the future!


3

Running it with the same configuration does not provide you with a performance gain. It is the same engine and the same optimizer and so on. But you can configure the Enterprise version to act in parallel mode. So you can partition your table and indexes and your multi-CPU server can (theoretically) improve the performance (by factors). This also depends on ...


3

Visiting the equivalent page in the 11g version of Oracle 2 Day DBA, I see that the monitoring you are referring to is now done in SQL Developer, rather than via web interface. It appears the web interface you were previously using is completely gone in 11g. Sorry for the bad news.


2

Here is how Oracle says you should install the loopback adapter for a 10g instance on XP.


2

I think by "primary network device" it is just meaning in your Oracle config (rather than setting your default route to go via localhost) so I don't think this is an issue. Oracle will bind to 127.0.0.1 instead of your non-local interface. In this case other machines won't be able to connect to your Oracle config, though this is probably not a problem on a ...



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