Tag Info

New answers tagged

0

So you are trying to say that now my new user on server is using USER tablespace untill there is a enough space and after will continue to use DATATAB tablespace or not? Could I have problems in future? I dont understand why if new user on server is related to DATATAB tablespace and dmp is imported to that user, does use old tablespace from old user from ...


-3

TRUNCATE TABLE_NAME; does the magic for you.


-2

You should use TRUNCATE instead of DELETE if you is using SQL Server. Because it will reduce log records in log file. USE <your database>; GO DECLARE @table_name varchar(100); DECLARE c CURSOR FOR SELECT name FROM sys.tables WHERE type='U' OPEN c FETCH NEXT FROM c INTO @table_name WHILE @@FETCH_STATUS =0 BEGIN EXEC (N'TRUNCATE TABLE ...


2

Generate the statements you need select 'DELETE FROM '||table_name||' ;' from user_tables;


0

Why using original Export and Import utilities (imp and exp respectively), which are deprecated, while since 10g Oracle provides a new, more efficient facility called Data Pump? You can use Data Pump Import with REMAP_TABLESPACE parameter to specify the new tablespace name for the objects being imported: $ impdp hr REMAP_TABLESPACE=tbs_1:tbs_6 ...


2

It means that possibly some other DBA issued the command below (alter system with optional comment clause). Then the comment is put into spfile this way. But as I read metalink note: 257643.1 it might some outcome of some changes in automatic memory management. See alter system command: alter system set sga_max_size=2G scope=spfile sid=* ...


2

Use this on Windows (three nested double quotes): exp system/password_for_system@dev file=c:\fooadmin.dmp full=yes imp """sys/password12345@dev as sysdba""" FROMUSER=FOOADMIN TOUSER=FOOADMIN file=c:\fooadmin.dmp In general imp would work as intended with sys account, it is just not recommended. But exp with sys account could possibly produce inconsistent ...


1

First you need to convert it to TIMESTAMP datatype (because DATE type does not handle fractions of second). Then you can truncate it to date for example: alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS'; with data as (select '2012/09/06-21:17:30:019' as lastupdate from dual) select trunc(to_timestamp(lastupdate, 'YYYY/MM/DD-HH24:MI:SS:FF3')) ...


0

I think you need to either qualify type with schema when using client account (CO_ADMIN.DOCPARAMETERTYPE_TABLE, not just DOCPARAMETERTYPE_TABLE ) or create a public synonym for the type.


0

The only reason that I can think of is that the system was on the limit of physical memory and using a little bit of virtual memory (on Windows, paging file). Once you add more memory to Oracle, you push a lot of that buffer out of physical memory, which causes a huge increase in response time due to paging. Having a lot of paging taking place on an Oracle ...


-1

configure the listener using Net Configuration Assistant or delete and recreate the listener with the same name and port


0

You just need to use NOT IN SELECT * FROM table1 WHERE col1 NOT IN (SELECT colA FROM table_2)


2

Views starting with VW_DTP showing up in the execution plan is the result of one of the cost-based query transformations available since 11.2, called distinct placement. It happens with statements using the DISTINCT clause, just like yours. It is an absolutely acceptable an quite obvious execution plan to join the tables and filter the rows, and after that, ...


3

The correct answer for licensing questions is: contact your oracle sales representative. With Oracle you license cpu's. If your test and prod run on the same cpu's, they don't need a new license. As long as it all runs on the same cpu's, it does not matter if you have multiple databases (and instances) or run it all in one single database. Normally we don't ...


0

I found the Answer after long investigation, the problem in my case is root.sh under $ORACLE_HOME/root.sh is not running fine, so in-order to fix this issue I need to use root user then navigate to $ORACLE_HOME and execute the script. it will ask you to Enter the full pathname of the local bin directory: [/usr/local/bin] enter the correct values and replace ...


1

DBCA relies on /etc/oratab. If that file is empty, or the entry for the database you want to delete is missing, the option(s) will be disabled.


1

In Oracle BEGIN starts a PL/SQL block. In other words, after BEGIN you ought to provide a text of a program that is written in a procedural language that is somewhat different than SQL (although it bears some similarities). Your sqlplus had read everything but it was not yet parsing or executing anything, it was waiting for an END and a line containing only ...


0

Oracle said no, only [a...z] [A...Z] [0...9] _


0

Try with this tutorial, and good luck Installing java, oracle 11g r2 express edition and sql developer


1

Oracle's transactions are implicit in sqlplus you're already in one and don't have to start it. This means you can just do select ... update .. rollback ... select... if you do an exit without doing exit rollback it will commit on exit. begin is not necessary here.



Top 50 recent answers are included