Oracle database backup and recovery

Email Alerts

Register now to receive SearchOracle.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

  • Getting PLS-00201 error while exporting schema

    I had a problem while exporting a schema and followed your advice regarding this error: "PLS-00201: identifier 'XDB.DBMS_XDBUTIL_INT' must be declared." The package did not exist so I ran the script "@?/rdbms/admin/prvtxdb.plb" you recommended. There...  Ask the Expert

  • Exporting data only to new database

    I have a new database created in Oracle 9i. Except for data it has all the other objects in this database. I'd like to export the data only from the old database and import it to the new database.  Ask the Expert

  • Errors with select query on dblink

    I created a dblink, but when I execute the select query, it throws the following errors: "TNS: could not resolve service name" or "TNS: no listener." Can you help?  Ask the Expert

  • Exporting large database with minimum access to system

    I need to export a large database with minimum access to the system, so I need to test my export script in isolation. This script gives me a warning that it has ignored the FILESIZE parameter and changed it to zero. What do you suggest?  Ask the Expert

  • Importing table structure only to new schema

    How do I import the table structure only to another schema with a different tablespace for data, as well as for constraints?  Ask the Expert

  • Tablespaces and users don't exist

    I'm importing a dump file from another Oracle database into Oracle 10g. I'm using the command line with "full=y" with the "system" login, but I get many errors about tablespaces and users not existing. I have tried turning off grants, with no luck.  Ask the Expert

  • Taking Oracle backup using Perl

    How can I take a backup in Oracle to a particular destination using Perl (CGI script)? Is it possible to take the backup to the image database also?  Ask the Expert

  • Clone Oracle database without exp/imp

    Is it possible to clone a database (Oracle 9i Release 2) from Solaris 5.8 to Linux Enterprise Edition 3 without exp/imp?  Ask the Expert

  • Restoring database on test machine

    I have one server with Oracle 9.2.0.1 on Windows 2003 Server. My server is running in archive mode. Now I want to restore this database to one of our test machines.  Ask the Expert

  • Command to increase size of datafile

    How can I increase the size of a datafile in any tablespace (what is the command)? How can I be sure that I have increased the right file size in the right schema?  Ask the Expert

Back to top